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.

NTSB ANC96TA095Accident · Minor injuriesFinal reportCessna 185 · Fairbanks, AKfatigue failure of the engine crankshaft. A factor related to the accident was: the lack of suitable terrain for a forced landing.Jul 4, 1996 · N185CA · DestroyedNTSB MIA96LA174Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Kinston, NCfailure of the pilot to maintain minimum descent altitude (MDA) during approach because of fatigue.Jul 3, 1996 · N23806 · Substantial damageNTSB FTW96LA298Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Ardmore, OKThe pilot's inadvertent premature retraction of the landing gear during takeoff roll. A factor was inadequate supervision by the safety pilot/flight instructor.Jul 3, 1996 · N2992F · Substantial damageNTSB FTW96LA291Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Castle Rock, COTotal failure of the magneto. A factor was the pilot operating the helicopter with a known deficiency.Jul 3, 1996 · N51763 · Substantial damageNTSB ANC96LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cantwell, AKThe pilot's inadequate compensation for the crosswind conditions. A factor in the accident was the crosswind.Jul 3, 1996 · N57617 · Substantial damageNTSB SEA96LA141Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Paris, IDthe pilot forgot to extend the landing gear before landing. Factors relating to the accident were: an interuption of the pilot's habit pattern, when he circled to provide time for another airplane to takeoff as he entered the traffic pattern; and his failure…Jul 2, 1996 · N5246P · Substantial damageNTSB SEA96LA140Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Jackson, WYAn improper screw installation by an unknown individual into the instrument panel, which restricted movement of the gear handle resulting in premature disengagement of the normal landing gear extension system. A factor was one or more improperly adjusted nose…Jul 2, 1996 · N27518 · Substantial damageNTSB NYC96LA139Accident · 1 fatalLimited investigationFinal reportTitan Tornado · Richland, NYfailure of the student pilot to maintain adequate airspeed, during an apparent go-around, which resulted in an inadvertent stall and subsequent collision with the terrain. Factors relating to the accident were: the pilot's lack of certification, and…Jul 2, 1996 · UNREG · DestroyedNTSB NYC96LA138Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Wolfeboro, NHThe pilot's improper flare, which resulted in a hard landing and nose over. The glassy water condition was a related factor.Jul 2, 1996 · N51DG · Substantial damageNTSB MIA96LA173Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Knoxville, TNFatigue failure of the blade No. 1 hub arm of the left propeller.Jul 2, 1996 · N3061P · Substantial damageNTSB LAX96LA259Accident · Minor injuriesLimited investigationFinal reportBeech 95-B55 · Ramona, CAThe pilot's failure to maintain directional control of the aircraft.Jul 2, 1996 · N386T · Substantial damageNTSB LAX96LA258Accident · 1 fatalLimited investigationFinal reportDavis Challenger I CW · Paso Robles, CAthe owner/builder/pilot's impairment of judgment and performance due to drugs which led to his improper handling of the airplane and failure to maintain an adequate airspeed margin above stall speed, resulting in an inadvertent stall/spin. A factor which…Jul 2, 1996 · N75489 · DestroyedNTSB LAX96LA257Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Redlands, CAthe CFI's delayed remedial action by not preventing the airplane's departure from the runway, and his failure to maintain airspeed sufficient to avoid stalling during an attempted low altitude climbing turn.Jul 2, 1996 · N2931V · DestroyedNTSB IAD96LA106Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Beckley, WVThe pilots decision to continue flying from VFR to IMC conditions which subsequently forced him to make a precautionary landing onto unsuitable terrain.Jul 2, 1996 · N8099A · Substantial damageNTSB IAD96LA103Accident · Serious injuriesLimited investigationFinal reportAero Commander Calair A-9B · Cloverdale, OHPowerplant failure due to undetermined reasons. Contributing to the severity of the crash was the unsuitable terrain in which the aircraft landed and post-crash fire.Jul 2, 1996 · N7730V · DestroyedNTSB FTW96TA289Accident · Minor injuriesFinal reportCessna 182RG · Broomfield, COfailure of the pilot to maintain directional control and runway alignment during a go-around, and the lack of power response from the engine for undetermined reason(s). The sudden wind shift was a related factor.Jul 2, 1996 · N4314R · Substantial damageNTSB FTW96LA287Accident · No injuriesLimited investigationFinal reportCessna 421B · Stillwater, OKthe failure of the pilots of the Cessna 421B, N450SU, and the Cessna 152, N94532, to maintain visual lookout. Factors were: the inadequate radio communications maintained by both pilots, and the failure of the student pilot of the Cessna 152 to take evasive…Jul 2, 1996 · N450SU · 2 aircraft · Substantial damageNTSB FTW96FA288Accident · 1 fatalField investigationFinal reportAir Tractor AT-400 · Huffman, TXcorroded flight control components, due to the operator's inadequate maintenance and inspection of the airplane; the pilot's failure to follow procedures and directives, by flying the airplane without proper maintenance and annual inspection; and subsequent…Jul 2, 1996 · N501JS · Substantial damageNTSB SEA96LA139Accident · No injuriesLimited investigationFinal reportAgusta A109 · Newport, ORthe pilot's failure to adequately compensate for the gusty wind condition during the landing. The gusty wind was a related factor.Jul 1, 1996 · N808GM · Substantial damageNTSB NYC96LA135Accident · No injuriesLimited investigationFinal reportBell 206B III · South Carver, MAThe pilot's failure to maintain control of the helicopter during an aerial application maneuver. This put the helicopter in a low slow down wind, high power demand turn, where it encountered a loss of tail rotor effectiveness, and the subsequent collision…Jul 1, 1996 · N444JB · Substantial damageNTSB LAX96LA256Accident · No injuriesLimited investigationFinal reportMooney M20E · Rio Linda, CAThe pilot's failure to attain/maintain the proper approach airspeed, his failure to attain the proper runway touchdown point, and his failure to initiate a go-around when a landing overshoot became apparent. A factor in the accident was the airport…Jul 1, 1996 · N3229F · DestroyedNTSB FTW96LA290Accident · No injuriesLimited investigationFinal reportCessna 172L · Johnstown, COfailure of the pilot to maintain proper altitude/clearance from obstructions, while buzzing.Jul 1, 1996 · N19682 · Substantial damageNTSB FTW96LA286Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Almyra, ARThe pilot's failure to maintain aircraft control. A factor was the pilot's excessive use of flaps during the maneuver.Jul 1, 1996 · N7314C · DestroyedNTSB FTW96LA285Accident · No injuriesLimited investigationFinal reportHiller UH12 · Franklin, LAloss of engine power for undetermined reasons, and the pilot's failure to maintain rotor RPM. A factor was the unsuitable terrain available for the precautionary landing.Jul 1, 1996 · N14637 · Substantial damageNTSB FTW96FA282Accident · No injuriesField investigationFinal reportSaab-Scania SF340B · Dfw Airport, TXThe manufacturer's inadequate procedure for manufacturing the number two turbine disk.Jul 1, 1996 · N335AE · Substantial damageNTSB CHI96LA226Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 Viking · Alexandria, MNthe flight instructor's failure to assure a proper fuel tank selector position. Factors associated with the accident were improper preflight preparation and complacency by the flight instructor.Jul 1, 1996 · N838MM · Substantial damageNTSB CHI96LA225Accident · Serious injuriesLimited investigationFinal reportSisk BD-5 · Lake Geneva, WIfailure of the pilot to abort the takeoff, while there was sufficient runway remaining. The high temperature and calm wind were related factors.Jul 1, 1996 · N51SK · DestroyedNTSB ATL96LA099Accident · No injuriesLimited investigationFinal reportCessna 188 · Pelham, GAfailure of the pilot to maintain directional control on the takeoff roll, which resulted in the airplane veering off the runway and colliding with a cotton picker (vehicle).Jul 1, 1996 · N9088R · Substantial damageNTSB NYC96LA137Accident · No injuriesLimited investigationFinal reportCessna 152 · Mansfield, MAan animal (deer) that wandered onto the runway. The light condition (at dusk) was a related factor.Jun 30, 1996 · N48750 · Substantial damageNTSB MIA96LA172Accident · No injuriesLimited investigationFinal reportCharles Raymond Glasair 2SFT · Apalachicola, FLInadequate application of throttle input and up elevator input by the pilot-in-command. Contributing to the accident was the in-flight encounter with a downdraft and inadequate design of the airplane by the kit manufacturer.Jun 30, 1996 · N16CD · Substantial damageNTSB LAX96LA261Accident · No injuriesLimited investigationFinal reportRominger Eyas · Santa Rosa, CAan inadequate design change by the pilot/builder of the airplane's canopy; a malfunction of the canopy, which resulted in its separation; and failure of the pilot to flare the airplane during an emergency landing after takeoff, due to the wind blast that…Jun 30, 1996 · N8012U · Substantial damageNTSB LAX96LA255Accident · No injuriesLimited investigationFinal reportCessna 172 · Frazier Park, CAthe failure of the pilot to maintain terrain clearance after a misjudged approach and landing that necessitated a go-around and subsequent collision with some wires. Factors were high density altitude and an inadequate evaluation by the pilot-in-command of…Jun 30, 1996 · N6819H · Substantial damageNTSB IAD96LA102Accident · Serious injuriesLimited investigationFinal reportBeech 65 · Campbellsville, KYthe pilot's inadequate preflight preparation, his failure to remove the control lock, and his failure to abort the takeoff.Jun 30, 1996 · N3870C · DestroyedNTSB FTW96WA310Accident · 2 fatalForeign investigationAerospatiale SA315B · La Peruanita, PeruJun 30, 1996 · N32074 · DestroyedNTSB FTW96LA281Accident · No injuriesLimited investigationFinal reportCessna 172H · Pierce, COa loss of engine power for undetermined reasons. A factor was the unsuitable terrain.Jun 30, 1996 · N1686F · Substantial damageNTSB FTW96LA280Accident · No injuriesLimited investigationFinal reportCessna 182N · Truth Or Conseq, NMThe loss of engine power due to the fatigue failure of the number one piston. A factor was the lack of suitable terrain for the forced landing.Jun 30, 1996 · N9001G · Substantial damageNTSB CHI96LA303Accident · No injuriesLimited investigationFinal reportCessna A188B · Watford City, NDthe pilot's failure to maintain directional control while landing on a road.Jun 30, 1996 · N21744 · Substantial damageNTSB CHI96LA223Accident · No injuriesLimited investigationFinal reportBell TH-13T · Mandan, NDthe pilot's failure to maintain clearance from known transmission lines. A factor relating to this accident was the sunglare which hindered the pilot's ability to see the transmission lines.Jun 30, 1996 · N96161 · Substantial damageNTSB ATL96LA098Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Calhoun, GAthe pilot's failure to maintain directional control during landing.Jun 30, 1996 · N7685K · Substantial damageNTSB SEA96LA138Accident · No injuriesLimited investigationFinal reportCessna A188B · Opheim, MTthe pilot's failure to follow the proper short field takeoff procedure as specified in the Airplane Flight Manual, his improper use of wing flaps during the takeoff, and his failure to abort the takeoff (while there was sufficient runway remainin). A factor…Jun 29, 1996 · N731ED · Substantial damageNTSB NYC96LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bridgeport, CTthe student pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing.Jun 29, 1996 · N8119H · Substantial damageNTSB MIA96WA170Accident · No injuriesForeign investigationBeech D18S · Rock Sound, BahamasJun 29, 1996 · N354T · Substantial damageNTSB MIA96LA171Accident · No injuriesLimited investigationFinal reportBeech B35 · Kissimmee, FLthe pilot was operating the airplane at an indicated airspeed that exceeded the design speed for maximum gust intensity (VB), when clear air turbulence was encountered.Jun 29, 1996 · N5136C · Substantial damageNTSB LAX96LA254Accident · Minor injuriesLimited investigationFinal reportGray Berkut · Santa Paula, CALoss of engine power during final approach for undetermined reasons. A factor in the accident was the nature of the terrain for the forced landing.Jun 29, 1996 · N260DG · DestroyedNTSB LAX96LA253Accident · Minor injuriesLimited investigationFinal reportCessna P210 · Grand Canyon, AZfailure of the pilot to use his brakes to maintain directional control.Jun 29, 1996 · N4766K · DestroyedNTSB LAX96LA252Accident · No injuriesLimited investigationFinal reportCessna 402A · Grand Canyon, AZFailure of the pilot to properly judge his altitude during final approach resulting in an undershoot. A factor was a downdraft weather condition.Jun 29, 1996 · N13GM · Substantial damageNTSB LAX96LA251Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Rosa, CAthe solo student pilot misjudged the landing flare resulting in a hard landing. A factor in the accident was low airspeed.Jun 29, 1996 · N68459 · Substantial damageNTSB LAX96LA250Accident · No injuriesLimited investigationFinal reportCessna 172 · Camarillo, CAthe student pilot misjudged the landing flare resulting in a hard landing. A factor in the accident was high airspeed.Jun 29, 1996 · N9408L · Substantial damageNTSB FTW96LA283Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tulsa, OKThe student pilot's improper flare during the landing, which resulted in a collapsed nose gear, ground swerve, and collision with an object.Jun 29, 1996 · N7859W · Substantial damageNTSB FTW96FA279Accident · 2 fatalField investigationFinal reportPrevatt RV-6 · Boulder, COPoor judgment by the pilot of the RV-6, N194JP, in that he traversed an uncontrolled airport at traffic pattern altitude, failure of the pilots of both airplanes to see and avoid each other, and an inadvertent airplane stall encountered by the pilot of the…Jun 29, 1996 · N194JP · 2 aircraft · Destroyed