NTSB investigations
3,929 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases, newest first
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1 WHERE c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130) ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CHI87FA176Accident · 1 fatalField investigationFinal reportCessna 402B · Chicago, ILFailure of maintenance personnel to perform proper installation of the left throttle linkage.NTSB ATL87LA220Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Columbus, OHThe plt experienced a loss of directional control on ldg as the tailwheel touched down, and he executed a go-around. On the 2nd ldg attempt, the airplane veered off the rwy, traveled across a grassy area, and impacted a parked C-172. Post-crash exam of the…NTSB CHI87DEP09Accident · No injuriesFinal reportAyres 600S-2D · Bancroft, WIOn landing the aircraft veered to the right. Application of left brake and rudder did not arrest the turn. The aircraft impacted a fence post rendering substantial damage to the aircraft. Subsequent investigation revealed an axle spacer on the right wheel was…NTSB MIA87LA209Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Swiftown, MSWhile spraying cotton, severe vibration was felt throughout the acft & the plt elected a forced ldg. During the flare, the throttle was advanced to raise the nose, & the plt discovered the eng had totally failed. The acft flipped inverted on touch down. An…NTSB BFO87FA048Accident · No injuriesField investigationFinal reportAeronca 7AC · Saluda, VAWhile climbing thru aprx 400 to 500 ft after takeoff, the plt made a slight rgt turn which was flwd by a left bank. After moving the control stick for a left bank, it jammed to the left & was restricted in fore & aft movement. The plt applied full rgt rudder…NTSB MIA87LA207Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1121 · Jackson, MSDuring the ground run at 80 KTS the cabin door unsafe light illuminated. The takeoff was aborted with heavy braking & deployment of the thrust reversers. The door was then opened & reclosed which extinguished the light, & a second takeoff was attempted. Aprx…NTSB MKC87LA140Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Adams, NEAfter a normal approach and landing on a private sod strip, the pilot stated the aircraft swerved to the left of the runway to an adjoining plowed field. The aircraft struck a large hay bale followed by a large mound of dirt. Post accident investigation…NTSB MKC87LA139Accident · No injuriesLimited investigationFinal reportCessna 188B · Satanta, KSDuring the takeoff ground run on an aerial application operation, the right main gear leg separated approximately 10 inches above the axle. Acft became uncontrollable and struck the terrain. Post acc examination disclosed no defects which may have assisted…NTSB NYC87IA202Incident · No injuriesIncident investigationFinal reportBoeing 767-232 · Boston, MADelta flt 752, a Boeing 767, was nr the outer marker (om) on an ILS rwy 22L apch when the flt control sys sensed an uncommanded go-arnd. The acft drifted rgt of the localizer for ovr 1 min. At abt 1000' AGL, rwy 22R was sighted to the left & a normal landing…NTSB MKC87LA137Accident · No injuriesLimited investigationFinal reportAir Tractor AT301A · Baderville, MODuring an aerial application operation, the pilot experienced a violent engine vibration. He reduced power and attempted an emergency ldg. Acft nosed over on landing. The pilot exited aircraft through side window. Acft caught fire and was destroyed.…NTSB MKC87FA131Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Holdrege, NEWitnesses stated that the aircraft was performing a loop when the left wing failed upward and rearward causing the aircraft to plummet to the ground, out of control. The aircraft appeared to have been in trouble during the loop entry and throughout the…NTSB DEN87LA175Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Nimbus II · Hobbs, NMThe pvt plt was flying in a national soaring contest. The glider was towed to 2000 feet AGL and released. The plt reported making a climbing right turn after release, however he noticed that the control stick was more aft than normal. As the flight…NTSB ATL87LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Gulf Shores, ALThe plt aborted the takeoff about half way down the 3600 ft rwy after observing that the airspeed indicator was inop. Before he could stop the acft, it ran off the end of the rwy & went into a ditch. An exam by an A&P mechanic revealed that the pitot head was…NTSB FTW87DRG03Accident · Serious injuriesFinal reportWayne Hooks Cassutt III-M · Burnet, TXOn July 7,1987, a cassutt 111M, N3790A, impacted the runway at kate craddock field (T-27) Burnet Texas. The pilot was conducting the initial test flight of the home built aircraft when the canopy came open. The pilot attempted to land the aircraft while…NTSB FTW87DRD08Accident · No injuriesFinal reportGrumman G-164A · Lacassine, LAThe pilot stated the aircraft's tail wheel broke during the takeoff roll causing the aircraft to veer to the right. The right wing contacted a small tree and the right main gear wheel dropped into a ditch which was parallel with the runway. Directional…NTSB NYC87DNC07Accident · 1 fatalFinal reportMcculloch Monerai "S" · Springfield, VTThe monerai 's' (N54MS, a pwrd glider) experienced an inflt failure of the left wing spar & crashed. An investigation revealed the acft was being operated in excess of its max gross wt limit of 450 lbs. The plt of an unpowered monerai said he & 3 others…NTSB ATL87LA198Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · St Marys, GAAfter returning fm a local ngt flt, the acft was lndd gear up when the lndg gear did not extend. The acft bgn burning after it came to rest. It was extensively damaged by fire & the cause of the gear malfunction was not determined. Local police, who responded…NTSB FTW87FA161Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · El Paso, TXEscaping hot exhaust gas from the broken exhaust manifold melted the sealant from several areas of the firewall where hoses, wires, etc., pass through to the cocipit area. Heavy black smoke produced by smoldering wire insulation, fire shield material, etc.,…NTSB FTW87FA156Accident · 1 fatalField investigationFinal reportAerospatiale AS-355-F1 · Venice, LAOne of the mechanics who performed maintenance on the aircraft main rotor head stated that he was not sure that he installed the retaining bolts which secured the vibration absorber assembly to the aircraft. Metallurgical analysis of the assembly indicated…NTSB DEN87LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Lordsburg, NMWhile en route on a x-country flt, a severe eng vibration began. The plt reduced power & slowed the airspeed to reduce the severity of the vibration. Subsequently, he elected to make a wheels-up landing on rocky desert terrain. After landing, he discovered…NTSB MKC87LA128Accident · No injuriesLimited investigationFinal reportLowder Quickie II · Iowa City, IAThe PIC rptd normal takeoff and climb during a LCL flt. Abt 15 min into the flt, the PIC experienced a nose down pitching. Throttle was reduced and level attitude was established. The PIC rptd difficulty maintaining level flt and made a precautionary lndg on…NTSB LAX87LA252Accident · No injuriesLimited investigationFinal reportBeech A35 · Santa Rosa, CAThe plt was participating in a cafe-400 (comparative acft flt efficiency) contest over a 400 mi, round robin course. While dscndg fm 7000' at the end of the flt, the plt slowed the acft to 140 mph to observe traffic. When clear, he increased the speed to 160…NTSB LAX87LA245Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Tucson, AZAt the end of a business flt, the plt extended the landing gear and noted that the left main landing gear indicated that it was not down and locked. The plt activated the emergency landing gear extension which still indicated it was not down. While on final…NTSB DCA87IA037Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-30 · Miami, FLEal flight 23 experienced a rapid decompression during descent into Miami. Flight 23 departed lax with 3 flight crew, 8 f/a and 210 pax. On climbout the s/o observed that the manual outflow valve control wheel did not move toward the 1/2 closed position as it…NTSB ATL87DEI06Accident · 2 fatalFinal reportSteen Skybolt · Wadsworth, OHThe accident occurred when the pilot was practicing aerobatics. The investigation disclosed that linkage control rods between the pilot's stick and the pitch elevator was broken. The evidence indicated that the failure was caused by a combination of…NTSB NYC87LA185Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Southbridge, MADuring landing roll, a failure of a tire tube caused a flat tire and control of the aircraft was lost. When the tire was dismantled, the inner tube was found to be defective at the joint seam. Total time on the acft and tire WAS407 hrs. The acft had a 100 hr…NTSB CHI87LA157Accident · No injuriesLimited investigationFinal reportCessna 172P · Ft. Wayne, INThe pilot reported that the airspeed indicator failed in flight. The aircraft landed hard and porpoised. The nose wheel broke off and the aircraft skidded down the runway grinding off the bottom of the carburetor. A fire broke out destroying the aircraft.…NTSB NYC87LA182Accident · No injuriesLimited investigationFinal reportMaule M-4 · Wellsville, NYThe flight experienced a violent shimmy upon t/d and the acft veered to the right. The pilot made a go-around and experienced the same condition on the second t/d. on the third t/d, the pilot landed but was only able to maintain control of the acft until it…NTSB MIA87LA190Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Miami, FLThe instructor plt stated that the helicopter began to vibrate while the student plt was maneuvering it during an instructional flt. The instructor plt then executed a forced landing and upon touchdown the main rotor blades contacted the ground. Inspection of…NTSB DEN87FA153Accident · No injuriesField investigationFinal reportConcept 70 · Durango, COThe plt reported that he had been flying for one hour and had been doing acrobatics. He had started an inside loop and during pull up, he reported indicating 5.5 g's on his new g meter. The plt reported that both wings left the acft and he jettisoned the…NTSB DEN87FA148Accident · 2 fatalField investigationFinal reportMooney M20K · Broomfield, CODrg takeoff, the baggage door (bd) came open. Twr psnl advised the plt, but recd no discernible reply. At aprx 100' AGL,the acft pitched up & rolled left, then entered a steep dscnt & crashed aprx 500' left of the rwy. Except for the bd, nopreimpact mech…NTSB CHI87LA146Accident · No injuriesLimited investigationFinal reportCessna 210M · La Porte, INThe acft was damaged when the left main gear collapsed drg a landing. An investigation revealed that a swaged fitting at the end of a hydraulic line in the gear sys had failed. The plt rprtd that with this failure, the left main gear only partially extended.NTSB CHI87DET06Accident · No injuriesFinal reportKennedy Avid Flyer · Goshen, INWhile cruising at 1600 feet MSL, one propeller blade failed in the root area and departed the engine. The pilot made a successful emergency landing in a farmer's field. Vibrations, resulting from the unbalanced propeller condition, were of sufficient…NTSB CHI87IA148Incident · No injuriesIncident investigationFinal reportDornier DO-228-201 · Springfield, ILThe flightcrew experienced inflight opening of the aft baggage door and inflight separation of the cabin stairway door. The copilot checked the doors on three occasions before takeoff because the door warning light was illuminated. The captain initiated the…NTSB CHI87LA143Accident · No injuriesLimited investigationFinal reportCessna 172N · Prairie Duchien, WIWhile in cruise flight, tape which was holding a piece of plexiglass over the cracked windshield came loose. The windshield lifted up and the pilot was not able to maintain altitude. During the forced landing in a soft field. The nose gear sheared off.NTSB ATL87IA166Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Columbus, OHFlt attendant rpted smoke in cabin and pungent odor which dissipated. After descent for landing was begun smoke and odor returned. Pax informed flt crew of smoke intensity and precautionalry landing was made at divert field. Subsequent exam revealed that the…NTSB ATL87LA169Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Franklin, NCA 17 inch portion of one of the prop blades fractured and separated from the 76 inch dia prop while the acft was at cruise. During the forced landing the acft struck a fence post. Examination of the prop revealed the presence of filiform corrosion across the…NTSB NYC87LA162Accident · No injuriesLimited investigationFinal reportCessna 182 · Vera Cruz, PAThe plt rprtd that while en route at 3500 ft, the eng began to vibrate. About 1 min later, oil started covering the windshield & the cockpit began filling with smoke. He shut down the eng & looked for a place to land. Before landing, he restarted the eng, but…NTSB LAX87IA230Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Los Angeles, CAOver the outer marker, the captain extended the flaps to 50 degrees. As the flaps extended past 35 degrees, the airplane rolled to the left. The flaps were retracted to the 35 degree position and a go-around was executed. The flaps were set at 22 degrees and…NTSB CHI87FA139Accident · 2 fatalField investigationFinal reportBell 47G · Dayton, MNAircraft collided with terrain after tailboom structure failed because of internal corrosion. The aircraft was not registered at the time of the accident and the pilot/operator failed to assure that proper or timely preventive maintenance was performed on the…NTSB ATL87LA157Accident · No injuriesLimited investigationFinal reportBeech A36 · Greenville, SCThe plt made a precautionary ldg after experiencing acft electrical problems and observing the ammeter indicate discharging. The nose and rt main ldg gear collapsed during rollout braking. The plt reported that the gear had extended prior to ldg using the…NTSB ATL87LA156Accident · No injuriesLimited investigationFinal reportCessna C-152 · Bunn, NCThe airplane nosed over during a precautionary ldg in a soft, dirt field. The plt and a mechanic had been ferrying the airplane back to its base after replacing the starter and battery solenoids, and the battery. The pre-flt run-up had revealed no problems…NTSB BFO87DID03Accident · No injuriesFinal reportHam Wizard · Chesapeake, VADrg flt, a portion of the exhaust stack broke off & struck the wooden prop. Aprx 1/3 of the prop separated & a severe vibration started. The plt shut down the eng & headed for an open field. Due to lack of altitude, he was barely able to clear nearby trees.…NTSB FTW87LA131Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Grand Prairie, TXDuring landing roll the right main landing gear tire failed causing a loss of directional control. The acft departed the right side of the rwy, and the right main landing gear collapsed.NTSB ATL87LA151Accident · No injuriesLimited investigationFinal reportBeech A36-TC · Winder, GAThe plt reported experiencing a complete electrical failure shortly after takeoff. All systems were shut down and the plt declared an emergency. The flight descended to visual conditions for a landing at Winder. The plt shut down the engine and attempted a no…NTSB ATL87FA147Accident · 1 fatalField investigationFinal reportHiller UH-12D (H23) · Spartanburg, SCDuring a local pleasure flight above the treetops, the passenger reported that they heard a loud 'pop' over the sound of the engine. The plt told her that they were going down and she noticed the main rotor blades began to turn slower than usual before the…NTSB MIA87LA162Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Fernandina Bch, FLTail wheel strut was found to be over serviced causing it to be extended higher than normal. This would cause the aircraft to be harder to steer. On landing in a cross wind the pilot experienced vibration of the tail wheel followed by failure due to torsional…NTSB FTW87DPA02Accident · No injuriesFinal reportMoni Motor Glider · Terrell, TXThe pilot stated the cockpit canopy opened during initial climb at about 12 feet AGL and that this disrupted the air flow sufficiently that the aircraft became uncontrollable. The aircraft settled back onto the runway with a hard touchdown and then departed…NTSB FTW87LA126Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Austin, TXThe plt was unable to retract the landing gear after takeoff. The plt elected to return to the arpt and perform a precautionary landing. The touchdown was normal followed by the right main landing gear collapsing during the landing roll. The acft had…NTSB MKC87LA112Accident · No injuriesLimited investigationFinal reportCessna 150G · Forest City, IAAfter reaching a cruise alt of 1000 ft AGL, the plt noticed a lack of oil pressure. He elected to make a precautionary landing in an unplowed soft field. The plt then reduced pwr to idle and set up for the landing. During the landing roll the acft nosed over.…