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 LAX00LA200Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Los Angeles, CAThe pilot's loss of directional control during landing rollout due to the pilot's foot becoming wedged under a rudder pedal, which restricted its movement.May 21, 2000 · N8398K · Substantial damageNTSB FTW00WA171Accident · Serious injuriesForeign investigationCessna 182N · Nogales, MexicoMay 21, 2000 · N92755 · Substantial damageNTSB FTW00WA151Accident · 3 fatalForeign investigationBeech V35 · San Quintin, MexicoMay 21, 2000 · N3334G · DestroyedNTSB FTW00LA150Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Houston, TXThe pilot's failure to maintain control of the aircraft. Factors were the partially engaged parking brake and the pilot's diverted attention to the engine instruments.May 21, 2000 · N301TA · Substantial damageNTSB DEN00LA094Accident · No injuriesLimited investigationFinal reportCessna T210M · Laramie, WYThe pilot-in-command's failure to confirm, the landing gear was down and locked. Factors were the check pilot's failure to confirm the landing gear was down and locked, and the sun glare.May 21, 2000 · N66DF · Substantial damageNTSB DCA00MA052Accident · 19 fatalClass 1 · MajorFinal reportBritish Aerospace J-3101 · Bear Creek Town, PAThe flight crew’s failure to ensure an adequate fuel supply for the flight, which led to the stoppage of the right engine due to fuel exhaustion and the intermittent stoppage of the left engine due to fuel starvation. Contributing to the accident were the…May 21, 2000 · N16EJ · DestroyedNTSB SEA00LA089Accident · Serious injuriesLimited investigationFinal reportGifford TR-4 · Wenatchee, WAThe pilot's improper decision to attempt to close the canopy (entry door) after it inadvertently opened in flight, instead of making a precautionary landing with it open. Factors include the pilot's failure to follow all items on the checklist, his failure to…May 20, 2000 · N1757 · Substantial damageNTSB SEA00LA088Accident · Minor injuriesLimited investigationFinal reportAvions Mudry et Cie CAP 231 · Ephrata, WAThe pilot's failure to maintain aircraft control subsequent to the aircraft's canopy opening in flight. Factors include the pilot's failure confirm that the aircraft's canopy was secured prior to takeoff and impaired vision.May 20, 2000 · N231X · Substantial damageNTSB CHI00FA139Accident · 1 fatalField investigationFinal reportWsk Pzl Mielec M-18A · Muskegon, MIthe pilot's failure to maintain clearance from the trees. Factors relating to this accident were the low altitude and the trees.May 20, 2000 · N178RA · DestroyedNTSB MIA00WA167Accident · No injuriesForeign investigationPiper PA-28-140 · St. Barthelemy, WNMay 19, 2000 · N7150R · Substantial damageNTSB MIA00IA164Incident · No injuriesIncident investigationFinal reportBeech 1900C · Fort Lauderdale, FLThe failure of the first officer to comply with procedures and directives for his failure to assure that the forward airstair door was closed and locked. A contributing factor in the incident was the inoperative annunciation system of the forward airstair…May 19, 2000 · N154GA · Minor damageNTSB MIA00FA163Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Titusville, FLThe failure of the PIC to maintain control of the aircraft while in the simulated engine inoperative configuration in the landing pattern during a checkout flight resulting in an uncontrolled descent and collision with trees. A factor in the accident is the…May 19, 2000 · N3492P · DestroyedNTSB DEN00LA091Accident · No injuriesLimited investigationFinal reportCessna 172XP · Larkspur, COA forced landing on soft unsuitable terrain. Factors were improper wiring of the electric fuel boost pump, which produce high pressure when either on position was selected causing the engine to flood during the practice engine out approach.May 19, 2000 · N758SZ · Substantial damageNTSB DEN00FA092Accident · Minor injuriesField investigationFinal reportSwearingen SA226TC · Denver, COpropeller blade fatigue failure due to stress corrosion.May 19, 2000 · N235BA · Substantial damageNTSB ANC00TA059Accident · Minor injuriesFinal reportCessna 185F · Anchorage, AKThe pilot's improper remedial action and his failure to maintain directional control of the airplane during landing. A factor in the accident was the pilot's excessive use of the airplane brakes.May 19, 2000 · N1789 · Substantial damageNTSB ANC00LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Wasilla, AKThe pilot's inadequate compensation for wind conditions during takeoff. A factor in the accident was a sudden wind shift.May 19, 2000 · N49EB · Substantial damageNTSB SEA00LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Middleton, IDLoss of engine power for undetermined reasons.May 18, 2000 · N3054S · Substantial damageNTSB MIA00WA178Incident · No injuriesForeign investigationGrumman HU16A · Barbados, BarbadosMay 18, 2000 · N43GL · Minor damageNTSB MIA00LA162Accident · No injuriesLimited investigationFinal reportCessna A150M · Gainesville, GAThe pilot's failure to use proper soft field landing technique while attempting a forced landing to an open field following a loss of engine power which resulted in a hard landing. Factors in the accident were weather conditions conducive to formation of…May 18, 2000 · N9834J · Substantial damageNTSB LAX00LA199Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Biggs, CAThe broken exhaust valve rocker arm of the number 3 cylinder that resulted in a total loss of engine power during an aerial application flight.May 18, 2000 · N5335 · Substantial damageNTSB LAX00LA198Accident · No injuriesLimited investigationFinal reportCessna 185 · Borrego Springs, CAThe pilot's inadequate compensation for the crosswind condition and his subsequent failure to maintain directional control during landing.May 18, 2000 · N9955X · Substantial damageNTSB FTW00RA155Accident · 4 fatalForeign investigationCessna 182P · Coban, GuatemalaMay 18, 2000 · TGJORNTSB DEN00LA090Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Boulder, UTThe pilot's failure to take timely remedial action when he realized a low fuel state. Factors were fuel exhaustion and low airspeed.May 18, 2000 · N8803H · Substantial damageNTSB SEA00LA100Accident · No injuriesLimited investigationFinal reportCessna 172N · Atlantic Ocean (Atlantic Ocean)A loss of engine power for undetermined reasons.May 17, 2000 · N738VZ · DestroyedNTSB NYC00LA137Accident · No injuriesLimited investigationFinal reportAnderson MA-18 · Pittsburgh, PAThe pilot's improper fuel management which resulted in the loss of power, and his improper flare during the forced landing, which resulted in a hard landing. Factors included a restricted fuel supply due to a design flaw in the header tank/fuel valve/supply…May 17, 2000 · N218MA · Substantial damageNTSB MIA00LA160Accident · Minor injuriesLimited investigationFinal reportDaniel A. Shapiro Searey 1DK · Morganton, NCThe inadvertent forward elevator input by the pilot-in-command while reducing throttle control resulting in the airplane nose-over.May 17, 2000 · N8096A · Substantial damageNTSB MIA00LA159Accident · Minor injuriesLimited investigationFinal reportRichard Shaffer Aircamper GN-1 · Florence, SCThe failure of the pilot to maintain directional control after takeoff resulting in the uncontrolled descent and impact on a closed runway.May 17, 2000 · N2308C · Substantial damageNTSB DCA00WA050Accident · No injuriesForeign investigationBeech 1900C · GabonMay 17, 2000 · DestroyedNTSB NYC00FA136Accident · 1 fatalField investigationFinal reportBell UH-1H · Frenchville, PAForeign object damage to the compressor and turbine sections of the engine, which resulted in a loss of power.May 16, 2000 · N52AG · Substantial damageNTSB LAX00LA197Accident · Minor injuriesLimited investigationFinal reportBeech H35 · Show Low, AZThe pilot's failure to properly position the fuel selector to a tank with fuel resulting in fuel starvation, a loss of engine power, and subsequent collision with the ground during the final landing approach.May 16, 2000 · N5477D · Substantial damageNTSB IAD00LA043Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Tappahannock, VAthe pilots's inability to maintain aircraft control after a loss of consciosness.May 16, 2000 · N1655E · Substantial damageNTSB LAX00LA194Accident · No injuriesLimited investigationFinal reportCessna 152 · Borrego Springs, CAThe pilot's inadequate compensation for a crosswind condition during initial takeoff climb, which resulted a failure to maintain alignment and the airplane drifting into a nearby tree.May 15, 2000 · N25213 · Substantial damageNTSB IAD00LA042Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Gettysburg, PAThe pilot's improper pre-flight which resulted in the fuel strainer valve being left in the open position.May 15, 2000 · N91480 · Substantial damageNTSB DEN00GA089Accident · 2 fatalFinal reportCessna T337C · Alamogordo, NMthe pilot's failure to maintain aircraft control, and the subsequent inadvertent stall/spin. Contributing factors were the loss of engine power on both engines for unknown reasons and the terrain induced turbulence.May 15, 2000 · N2522S · DestroyedNTSB MIA00LA158Accident · No injuriesLimited investigationFinal reportPiper J-3 · Boca Raton, FLa loss of engine power due to undetermined reasons that resulted in a forced landing and substantial damage to the aircraft.May 14, 2000 · N70546 · Substantial damageNTSB MIA00LA157Accident · Serious injuriesLimited investigationFinal reportNavion L-17B · Sharpsburg, GATotal loss of engine power due to debris (aluminum) from an undetermined source found in the engine-driven fuel pump cavity resulting in the shearing of the hollow pump fuel shaft, and subsequent forced landing to none suitable terrain.May 14, 2000 · N4903E · Substantial damageNTSB MIA00LA156Accident · No injuriesLimited investigationFinal reportAsselyn CH701 · Wake Forrest, NCThe pilot's improper fuel management during a cross country flight resulting in a loss of engine power due to fuel exhaustion, and his failure to achieve the proper touchdown point during a forced landing. This resulted in the pilot forcing the airplane onto…May 14, 2000 · N942PS · Substantial damageNTSB MIA00LA155Accident · No injuriesLimited investigationFinal reportBeech 18 · Monroe, NCThe pilot's failure to maintain directional control during an attempted go-around, resulting in a loss of directional control, and subsequent collapse of the left main landing gear after the airplane departed the runway.May 14, 2000 · N6082 · Substantial damageNTSB MIA00LA154Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Highlands, NCTotal loss of engine power due to the obstruction (insect larva) of the left wing aft fuel system line resulting in a forced landing to non suitable terrain.May 14, 2000 · N6860B · Substantial damageNTSB MIA00LA153Accident · 2 fatalLimited investigationFinal reportMclarty Vans RV-4 · Apex, NCThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed resulting in an inadvertent stall and subsequent collision with terrain.May 14, 2000 · N45DR · Substantial damageNTSB CHI00LA137Accident · No injuriesLimited investigationFinal reportWeatherly 201C · Ionia, KSthe partial engine failure for undetermined reasons and the unsuitable terrain for landing encountered by the pilot. A factor to the accident was the hilly terrain condition.May 14, 2000 · N9198W · Substantial damageNTSB CHI00LA136Accident · Serious injuriesLimited investigationFinal reportBeech A23-19 · Holmen, WIthe pilot's failure to maintain directional control of the airplane during the landing. Factors associated with the accident were the crosswind, along with the runway light, windsock, garden, and swimming pool that the airplane contacted.May 14, 2000 · N5665S · Substantial damageNTSB NYC00LA135Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Wellington, OHThe pilot's failure to maintain aircraft control. A factor was the pilot's improper in-flight decision to abort the initial climb due to an open canopy.May 13, 2000 · N3872G · Substantial damageNTSB NYC00LA134Accident · 1 fatalLimited investigationFinal reportHing FLY Baby 1A · Keymar, MDAn overload failure of both flying wires, on the underside of the right wing, while the airplane was climbing, due to improper balance between the two flying wires, by unknown person(s).May 13, 2000 · N2685 · DestroyedNTSB NYC00LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA18-150 · Forest Hill, MDThe pilot's failure to maintain directional control while landing. Factors in this accident were the tailwind condition, and the pilot's lack of flight experience in tail-wheeled airplanes.May 13, 2000 · N9432P · Substantial damageNTSB NYC00LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Moneta, VALoss of power for undetermined reasons.May 13, 2000 · N6841B · Substantial damageNTSB LAX00LA196Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Casa Grande, AZThe student pilot's inadvertant movement of the fuel selector to the "off" positon when selecting the alternate tank, and the flight instructor's lack of verification that the fuel selector was in the proper position during the emergency procedure checklist.…May 13, 2000 · N4148R · Substantial damageNTSB FTW00LA148Accident · No injuriesLimited investigationFinal reportCessna 172H · Mesquite, TXThe flight instructor's inadequate supervision of the student pilot during the landing.May 13, 2000 · N2440L · Substantial damageNTSB DEN00LA088Accident · No injuriesLimited investigationFinal reportBeech V35B · Erie, COInadvertent cut off of the mixture by the pilot. Factors were: The passenger door opening, the pilot's inexperience in make and model, and rough, uneven terrain in the landing area.May 13, 2000 · N6643Q · Substantial damageNTSB DEN00LA087Accident · No injuriesLimited investigationFinal reportCessna 170B · Bedford, WYThe pilot's inadvertent ground loop. A factor was the soft grass airstrip.May 13, 2000 · N8319A · Substantial damage