NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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 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 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 ATL86FEI08Accident · Serious injuriesFinal reportFairchild 24R-46 · Canton, OHThe plt reported that he was taking off after making a touch and go ldg; as he 'pushed (the) throttle forward on lift-off (the) engine began to quit'. The engine subsequently quit altogether at about 200-300 feet AGL over the departure end of the rwy.…NTSB ANC86LA108Accident · No injuriesLimited investigationFinal reportCessna 170B · Blackburn, AKAcft undershot apch and crashed into a river while executing a low circling apch to land at a nearby gravel bar. Plt stated that he had been on duty for about 18 hrs, had flown 8.4 hrs that day hauling fish and that he was tired and 'playing around'. Acft…NTSB NYC86LA180Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kingston, NYThe student plt was on his 1st solo flt. After a go-around, his next apch was good until the acft encountered a gust of wind just before touchdown. Subsequently, the acft landed hard (hit on rear section), veered off the rwy & nosed over.NTSB MKC86LA150Accident · No injuriesLimited investigationFinal reportStainbrook Avid Flyer · Salina, KSThe PIC had been practicing touch and go landings at a private air strip. At 50 feet AGL the PIC stated the engine quit and he descended into the ground off the rwy. Post accident inspection of the eng revealed that the propeller reduction gearing had broken…NTSB MIA86LA209Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Marathon, FLFlight experienced loss of engine oil and subsequent seizing of the engine at which time the aircraft was ditched in the gulf of Mexico. Post crash examination of the engine revealed the oil line from the propeller govenor to the engine nose case had failed…NTSB FTW86LA129Accident · No injuriesLimited investigationFinal reportCessna 182C · Decker'S Island, TXDuring a beach take-off run of approximately 200 feet, the aircraft nose wheel sunk into the soft sand. The pilot tried to add power and pull the column back, however the aircraft nosed over into an inverted position.NTSB DEN86LA197Accident · No injuriesLimited investigationFinal reportCessna A150N · Akron, COThe plt stated the acft he was piloting encountered a severe downdraft during initial climbout, which forced the acft to the ground. Upon ground contact, the acft nosed over onto its back.NTSB CHI86LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Chicago, ILThe pilot was unable to get a down and locked indication for the left main gear and upon touchdown the left gear collapsed. Inspection revealed an internal failure of the left main actuator. The fluid had leaked past the o-rings and prevented the gear from…NTSB CHI86FA170Accident · Serious injuriesField investigationFinal reportGrumman AA5B · Benton Harbor, MIThe aircraft departed on runway 09. Passenger remembers the pilot starting to turn back to the airport when the wings went perpendicular to the horizon and the ground came rushing up. Teardown of the engine revealed a bent push rod and a split push rod shroud…NTSB ANC86LA106Accident · No injuriesLimited investigationFinal reportCessna 207 · Ekuk, AKThe pilot stated that during the approach to landing, the aircraft struck a tree stump short of the approach end of the runway.NTSB SEA86LA169Accident · No injuriesLimited investigationFinal reportCessna 170B · Roche Harbor, WAThe plt lost directional control of the aircraft during landing rollout with a crosswind. The aircraft drifted to the left of the runway at which time the plt applied full aft elevator, full right rudder and full right aileron. The plt reported the acft made…NTSB SEA86LA168Accident · No injuriesLimited investigationFinal reportBell 47G2A · Chehalis, WADuring an aerial applications maneuver, a complete loss of power occurred. The power loss was caused by failure of the connecting rod bolt. The acft was too low for autorotation and the aircraft struck the ground tail low. The main rotor blade then struck the…NTSB MKC86LA149Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Arkansas City, KSThe certified flight instructor stated that his intentions for this flight were to simulate an engine power loss during the early stages of the takeoff roll and have the student perform a rejected takeoff procedure. According to the c.f.I., at approximately…NTSB MIA86FA208Accident · Serious injuriesField investigationFinal reportAirbus Industrie A300B4-2C · West Palm Bch, FLThe captain stated that an announcement had been made that they were starting their descent into the miami area and turned the seatbelt sign on and the passengers had been instructed to return to their seats. Approximately 5 minutes later, turbulence was…NTSB LAX86LA291Accident · No injuriesLimited investigationFinal reportEnstrom EN-280-C · Los Altos, CAThe instructor stated that during a practice auto rotative landing the helicopter lost rotor RPM and a hard landing followed. On ground contact, the main rotor blades struck the tail cone, resulting in substantial damage. The instructor further stated that…NTSB LAX86LA290Accident · No injuriesLimited investigationFinal reportCessna 195B · San Diego, CAThe airplane departed montgomery airport, runway 28L, San Diego, CA. Shortly after departing a fire erupted in the upper cowling area. The pilot executed an emergency landing on runway 05, but landed hard. Examination of the wreckage disclosed the number 2…NTSB LAX86FA289Accident · 1 fatalField investigationFinal reportAmerican AA-1A · Santa Paula, CAAfter working for over 13.5 hours the pilot attempted to fly 160 miles to his home. The 1.3 hour flt was initiated between 0100 and 0200. It was a dark night and according to persons in the accident area a 200-400 ft broken/overcast cloud layer was present.…NTSB LAX86FA288Accident · 6 fatalField investigationFinal reportCessna T210N · Bullhead City, AZThe private pilot, who had accumulated approximately 450 hours of flight experience and his 5 passengers, arrived at the destination airport during darkness. This was the pilot's first landing at the uncontrolled airport and he was not familiar with the…NTSB FTW86LA128Accident · No injuriesLimited investigationFinal reportCessna U-206G · Decker'S Island, TXDuring take-off the pilot did not compensate for a strong crosswind and allowed the aircraft to drift sideways where the main gear collided with a fallen tree separating it from the aircraft and causing the aircraft to veer and collide with the ground.NTSB FTW86LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Georgetown, TXThe instructor pilot was instructing his student pilot in an engine shutdown for a multi-engine instructor rating, after which the engine would not restart. The instructor decided to land at the closest airport. While on final approach another aircraft landed…NTSB DEN86LA196Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Fargo, NDThe plt said that he activated the landing gear retraction switch during the landing roll. The gear retracted causing the acft to settle on the rwy.NTSB CHI86LA169Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Benson, MNThe pilot reported that he ran the right fuel tank dry before switching to the left tank in cruise flight. On final approach for a landing the engine began to falter and quit running shortly thereafter. The aircraft was landed short of the runway gear up in…NTSB ATL86LA204Accident · No injuriesLimited investigationFinal reportCessna C-152 · Conway, SCThe acft was based at an uncontrolled airstrip without fuel facilities. Prior to take-off, the plt refueled the acft from a 5 gal can and draining the fuel sumps. During an approach to land at Conway, SC, the acft lost power and a forced landing was made on a…NTSB ATL86FEG02Accident · Serious injuriesFinal reportSmith Miniplane · Miamisburg, OHThe acft crashed into a tree and the ground during a forced landing after a pwr loss from fuel exhaustion. The plt said that he had 10 gals of fuel at takeoff and after 20 mintues of flt the gauge indicated 5 gals. During the attempt to return to the arpt the…NTSB SEA86LA167Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Boise, IDWhile taxiing for takeoff an inadvertant ground loop occurred during which the acft veered left striking another parked acft. The plt stated it felt as though the tailwheel jammed; however, post accident exam failed to disclose any failure/malfunction.NTSB SEA86LA166Accident · No injuriesLimited investigationFinal reportRockwell S2R · Royal City, WAShortly after takeoff at an alt of aprx 110 ft AGL, a loss of pwr occurred due to the #2 cylinder failing. The acft nosed over during the subsequent forced landing in a wheat field. The plt then extinguished a small exhaust fire.NTSB NYC86FNC05Accident · Minor injuriesFinal reportBell 47G-5 · Walthamer, MEWhile on a spray run the pilot of the Bell 47 was blinded by the sun as he was turning. The aircraft struck power lines, control was lost and the helicopter crashed.NTSB MKC86FCJ03Accident · Serious injuriesFinal reportAero Commander Callair A-9A · Pleasant Dale, NEA witness reported the acft pulled up with one wing high and went practically inverted before striking the ground in a steep nose down attitude. The acft was engaged in an aerial application operation when the accident occurred. The company owner stated the…NTSB MIA86LA207Accident · No injuriesLimited investigationFinal reportCessna 150E · Wakulla Springs, FLThe plt stated that while on final approach, the airspeed was too fast. When the acft touched down it began to porpoise, he lost control and the acft flipped over and came to rest inverted.NTSB MIA86LA206Accident · No injuriesLimited investigationFinal reportCessna 195A · Orlando, FLThe plt stated that the left main gear collapsed while he was trying to recover from a 45 degree swerve to the right during lanidng.NTSB MIA86LA205Accident · No injuriesLimited investigationFinal reportCessna R182 · Jacksonville, FLAfter the plt applied carb heat during the approach sequence, he became concerned about roughness in the eng. At about that same time, the tower cleared him to land behind another acft; however, at 1st, he did not have the other acft in sight & spent several…NTSB FTW86LA125Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Broken Arrow, OKThe pilot made his takeoff from the intersection of a cinder packed runway, allowing only 900 feet before the end of the runway. Gross weight of the aircraft at the time of the accident was 1,700 lbs.; maximum gross weight of the aircraft is 1,670. The…NTSB FTW86FA127Accident · 3 fatalField investigationFinal reportBeech 58 · Santa Fe, TXA pvt plt & instructor (CFI) were on a LCL flt with a 3rd occupant aboard. The purpose of the flt was to provide dual instruction to the pvt plt so he could obtain a multi-eng rating. At 1818, 1 of the plts contacted houston TRACON & reqdradar adzy & said…NTSB DEN86LA199Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · Hobbs, NMThe plt was participating in a soaring competion meet. While on the return portion of the flt, the plt encountered an area of insufficient lift & was unable to reach the arpt. During an off arpt landing, the left wing of the glider struck a mesquite bush &…NTSB DEN86LA195Accident · No injuriesLimited investigationFinal reportCessna 320C · Cedar City, UTThe plt said that while on downwind during his apch to land, he advanced the mixtures to full rich and retarded the throttles. On final approach when throttles were advanced, he discovered the right eng was not running and the left eng would not respond…NTSB DEN86LA185Accident · Minor injuriesLimited investigationFinal reportCessna 182P · New Castle, COPlt attempted to abort landing while on short final with 40 degrees of flaps. Plt decided that he would not clear trees at the FAR end of meadow so he executed a precautionary landing during which the acft struck a ditch and nosed over. The density altitude…NTSB ANC86LA107Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Port Moller, AKThe aircraft nosed over on landing rollout after landing on a beach.NTSB ANC86LA105Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Stoney River, AKAccording to a witness, a certificated pilot, a crowd had gathered to wave, watch the takeoff and take photographs. The airplane began its takeoff roll about mid point on the airstrip and rolled 120 feet before lifting off. The airplane climbed steeply and…NTSB SEA86FA165Accident · 2 fatalField investigationFinal reportThorp T-18 · Richland, WAAt time of mishap, acft presumed to be in rt-hand approach to land in 20-KT, 40 degree rt crosswind. Witnesses first observed acft descending vertically, out of control, in an area consistent with the 90 degree approach position. Evidence indicates acft…NTSB NYC86LA179Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Newburyport, MAPilot made a precautionary landing after experiencing a rudder control failure after a banner pick up. The left aft rudder cable had parted 49.5 inches aft of the rudder pedal attachment point.NTSB NYC86FA182Accident · 1 fatalField investigationFinal reportAeronca 7AC · Durhamville, NYAircraft departed rwy 35 at kamp airport, climbed to about 200 feet, turned right, stalled and crashed vertically into the ground. A witness said that the aircraft climbed, the engine sputtered, and then stopped. No preimpact malfunction/failure was…NTSB MKC86LA148Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Olathe, KSThe PIC had mistakenly attempted a landing at another airport 8 miles west of his intended destination. The PIC realized his mistake and diverted to his final destination. The PIC landed at the correct airport, but veered sharply to the right on landing on…NTSB MIA86LA204Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Kissimmee, FLThe plt rprtd that he initiated a flt around the pattern, but stalled the acft during the apch to land. The acft crashed outside the arpt boundry, just short of the rwy. Prior to the flt, a mechanic, who had been working on the acft, told the plt that the…NTSB LAX86LA287Accident · No injuriesLimited investigationFinal reportCessna 150M · Sunnymead, CAThe newly certificated flight instructor departed on a local dual instructional flight with a first hour primary student. The CFI said that 'due to numerous distractions' he 'forgot to check the fuel level and departed on the flight without an adequate fuel…NTSB FTW86LRD21Accident · No injuriesFinal reportGrumman G-164A · Abbeville, LAThe pilot stated he experienced a loss of engine power and made a forced landing in a wet pasture where the aircraft flipped inverted before coming to a stop. Subsequent engine examination failed to reveal a reason for the power loss. The owner reported that…NTSB FTW86LRD19Accident · Minor injuriesFinal reportAir Tractor AT-301 · Campti, LAThe acft crash landed from about 60 ft AGL after the eng quit during the end of a cotton spraying operation. The plt said he just dived & 'pancaked' which sheared the landing gear. The reason for the power filure is unknown. The plt said he has had 20 power…NTSB DEN86LA200Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-20B · Hobbs, NMThe plt said that he was participating in a glider soaring contest when the accident occurred. He stated that he was flying on the second leg of the flt when he ran out of thermals to keep his glider flying, and he was forced to land prematurely. On a…NTSB DEN86LA198Accident · No injuriesLimited investigationFinal reportCessna A188B · Center, COAccording to the plt involved in the accident the acft crashed during takeoff because the eng was not developing full power. The owner of the ag spraying business (to whom the acft belongs) and another plt for the operator, stated the mixture was improperly…NTSB DEN86LA194Accident · No injuriesLimited investigationFinal reportCessna 120 · Riverton, WYPlt stated after accident '... We could not climb after initial takeoff and a pwr line was coming up so I tried to turn right and the plane stalled.' The density altitude was calculated to be 7,136 feet MSL. The plt stated that he did not lean the mixture for…NTSB DEN86FA193Accident · 2 fatalField investigationFinal reportCessna 152 · Pierce, COThe acft reportedly departed the fort collins, Colorado, downtown arpt at 2151 MDT, July 10, 1986, on a local student night training flt. The wreckage was discovered at O800 MDT, July 11, 1986, in open, flat, cultivated terrain. The acft impacted in a steep…