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 LAX00FA122Accident · 1 fatalField investigationFinal reportPiper PA-12 · Cima, CAIn-flight collision with terrain for undetermined reasons.Mar 7, 2000 · N7586H · DestroyedNTSB FTW00LA090Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Manilla, ARThe pilot's performance of low altitude flight and his failure to maintain clearance with the power lines.Mar 7, 2000 · N20179 · Substantial damageNTSB ATL00LA037Accident · Minor injuriesLimited investigationFinal reportTitan Tornado · Springfield, TNThe loss of engine power for undetermined reasons, and the unqualified person attempted to fly the airplane.Mar 7, 2000 · NONE · DestroyedNTSB ATL00LA036Accident · 2 fatalLimited investigationFinal reportTrike Unknown · Dalton, GAThe pilot's failure to maintain appropriate clearance with objects during final approach to landing. A factor was the tree.Mar 7, 2000 · NONE · DestroyedNTSB ANC00IA034Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Fairbanks, AKA delayed rotation during takeoff for an undetermined reason.Mar 7, 2000 · N949AS · No damageNTSB SEA00LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Richland, WAFailure of a connecting rod for undetermined reasons. Factors include unsuitable terrain for the forced landing attempt.Mar 6, 2000 · N8170W · Substantial damageNTSB DCA00MA030Accident · Serious injuriesClass 1 · MajorFinal reportBoeing 737-300 · Burbank, CAthe flight crew's excessive airspeed and flightpath angle during the approach and landing and its failure to abort the approach when stabilized approach criteria were not met. Contributing to the accident was the controller's positioning of the airplane in…Mar 6, 2000 · N668SW · DestroyedNTSB ATL00LA034Accident · No injuriesLimited investigationFinal reportHughes 369D · Dallas, NCThe pilot's improper use of flight controls during an emergency landing. Factors were an encounter with a loss of tail rotor effectiveness (LTE) during an out-of-ground effect hover, the pilot's inadequate weather evaluation, and his failure to follow proper…Mar 6, 2000 · N303BT · Substantial damageNTSB NYC00LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · West Milford, NJThe pilot's failure to maintain directional control during landing. A factor in this accident was the gusty crosswind conditions.Mar 5, 2000 · N2761M · Substantial damageNTSB LAX00LA117Accident · No injuriesLimited investigationFinal reportPiper PA-46-310 · Palo Alto, CAThe pilot's failure to obtain/maintain the proper visual glide path resulting in an undershoot and collision with the runway edge.Mar 5, 2000 · N43412 · Substantial damageNTSB CHI00LA086Accident · Minor injuriesLimited investigationFinal reportAlon Ercoupe · Osceola, IAfuel starvation due to an undetermined blockage in the fuel line from the header tank to the gascolator. Factors relating to this accident were the blocked fuel line and the rough terrain.Mar 5, 2000 · N6560Q · Substantial damageNTSB ATL00LA033Accident · Serious injuriesLimited investigationFinal reportAero Comp COMP-AIR-6 · Indiantown, FLThe maintenance personnel inadequate inspection of the fuel system that resulted in loss of engine power due to fuel filter contamination.Mar 5, 2000 · N61520 · Substantial damageNTSB ATL00LA032Accident · No injuriesLimited investigationFinal reportBellanca 260 B · Cornelia, GAThe pilot's failure to use the checklist, resulting in a wheels-up landing and post-crash fire.Mar 5, 2000 · N8865R · DestroyedNTSB ATL00IA035Incident · No injuriesIncident investigationFinal reportCessna CE-560 · Key Largo, FLThe malfunction of the nose gear locking mechanism for undetermined reason.Mar 5, 2000 · N314QS · Minor damageNTSB ANC00LA032Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Fairbanks, AKThe pilot's inadvertent ground loop.Mar 5, 2000 · N6453M · Substantial damageNTSB ANC00LA031Accident · No injuriesLimited investigationFinal reportCessna 170B · Big Lake, AKThe pilot's selection of unsuitable terrain for takeoff. Factors in the accident were soft, snow-covered terrain, and an inadvertent ground loop.Mar 5, 2000 · N2814C · Substantial damageNTSB SEA00LA047Accident · No injuriesLimited investigationFinal reportCessna 180H · Bozeman, MTAircraft control was not maintained. Inadequate remedial action was a factor.Mar 4, 2000 · N9907V · Substantial damageNTSB NYC00LA087Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Rome, NYThe pilot inadvertently selecting the mixture control to off, resulting in a total loss of engine power.Mar 4, 2000 · N3719H · Substantial damageNTSB IAD00LA025Accident · Serious injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Blairstown, NJthe encountering of wind conditions in flight that inhibited the pilot from maintaining altitude.Mar 4, 2000 · N97VT · DestroyedNTSB ANC00LA033Accident · No injuriesLimited investigationFinal reportCessna 208B · Holy Cross, AKAn in-flight separation of a main landing gear tire mud flap, and subsequent impact with the horizontal stabilizer.Mar 4, 2000 · N407GV · Substantial damageNTSB MIA00FA102Accident · 2 fatalField investigationFinal reportMcDonnell Douglas HU-600N · Miami, FLThe pilot's ostentatious display and in-flight decision to perform an abrupt low altitude pitch up maneuver (aerobatic flight). This resulted in the main rotor blades colliding with and separating the tail boom assembly while maneuvering, and the helicopters…Mar 3, 2000 · N611BC · DestroyedNTSB ATL00LA031Accident · 1 fatalLimited investigationFinal reportunknown unknown · Manatee, FLThe pilot's impairment due to the use of unapproved medication which led to loss of control in flight.Mar 3, 2000 · UNREG · DestroyedNTSB NYC00WA090Accident · Serious injuriesForeign investigationCessna 414 · BotswanaMar 2, 2000 · DestroyedNTSB LAX00LA112Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Coalinga, CAThe failure of the landing gear for undetermined reasons to go into the locked position after the pilot conducted a manual and emergency gear extension. A factor in the accident was the undetermined failure of the electrical system.Mar 2, 2000 · N8170S · Substantial damageNTSB DEN00LA055Accident · No injuriesLimited investigationFinal reportCessna P210N · Gillette, WYThe pilot's failure to land sooner to refuel, resulting in a power loss due to fuel exhaustion. A factor was a lack of suitable terrain on which to make a forced landing.Mar 2, 2000 · N6489W · Substantial damageNTSB CHI00LA085Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Macomb, ILthe inadequate maintenance inspection prior to the ferry flight by the pilot/mechanic rated passenger who endorsed the airplane as airworthy, the shift in the number two main bearing left half, and the fractured crankshaft. A factor was the rough/uneven…Mar 2, 2000 · N9552T · Substantial damageNTSB NYC00LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Hazelton, PAThe pilot's failure to maintain directional control while landing with a crosswind.Mar 1, 2000 · N67639 · Substantial damageNTSB NYC00LA086Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-30F · Newark, NJThe tug operator's inadequate visual lookout.Mar 1, 2000 · N302FE · Substantial damageNTSB FTW00LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe pilot's failure to maintain aircraft control during landing. A factor was the crosswind condition.Mar 1, 2000 · N48821 · Substantial damageNTSB MIA00WA101Accident · Minor injuriesForeign investigationBell 214ST · Ras Tanura, Saudi ArabiaFeb 29, 2000 · N7824H · Substantial damageNTSB ATL00LA030Accident · Minor injuriesLimited investigationFinal reportBurak Stanley A XF4 · Brooksville, FLThe owner/builder's failure to build the airplane within the design stress limits of the drive shaft assembly, that resulted in the failure of the Flex Coupling Retention Bolts.Feb 29, 2000 · N9VY · Substantial damageNTSB NYC00LA085Accident · Serious injuriesLimited investigationFinal reportBoeing 747-236 · Providence, RIMaintenance personnel's failure to reconnect the pitot connections to the elevator feel computer which resulted in an elevator control surface deflection which was outside of the normal autopilot elevator authority. The uncommanded autopilot input to the…Feb 28, 2000 · GBDXL · No damageNTSB MIA00LA100Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Dandridge, TNthe student pilot's improper preflight that resulted in his operating an aircraft with contaminated fuel that resulted in a loss of engine power and a forced landing in the trees and damage to the aircraft. Contributing to the accident were the student's…Feb 28, 2000 · N6753S · Substantial damageNTSB MIA00LA099Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Brooksville, FLTotal loss of engine power for undetermined reasons on appr oach for landing resulting in an in-flight collision with a dirt bank, separation of the main landing gear, and subsequent nose over. Contributing to the accident was carburetor icing conditions.Feb 28, 2000 · N717NC · Substantial damageNTSB MIA00LA097Accident · No injuriesLimited investigationFinal reportHughes TH-55 · Odessa, FLThe pilot's improper use of flight controls (cyclic and col lective) during a autorotation resulting in a hard landing and subsequent roll over.Feb 28, 2000 · N9518K · Substantial damageNTSB IAD00FA024Accident · 1 fatalField investigationFinal reportCessna 337 · Prnce Frederick, MDwas the pilot's failure to maintain control of the airplane after a loss of engine power on one engine. Factors in the accident were the pilot/owner's failure to follow the published emergency procedure, his inadequate fuel management, and his intentional…Feb 28, 2000 · N53HS · DestroyedNTSB ATL00LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Titusville, FLThe pilot's improper decision to attempt a flight on minimal fuel, which resulted in a total loss of engine power due to fuel exhaustion. A factor was the closed fuel pumps at the departure airport.Feb 28, 2000 · N441WA · Substantial damageNTSB LAX00LA111Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · San Bernardino, CAthe total failure of the engine number 1 cylinder exhaust valve.Feb 27, 2000 · N99590 · Substantial damageNTSB LAX00LA110Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Big Bear City, CAThe pilot's selection of a final approach airspeed in variance with the manufacturer's recommendations, which was too slow for the gusty and variable crosswind conditions, which resulted in a stall/mush and a hard landing.Feb 27, 2000 · N15202 · Substantial damageNTSB DCA00WA029Accident · No injuriesForeign investigationBoeing B737-400 · Porto Alegre, BrazilFeb 27, 2000 · PTTEO · Substantial damageNTSB CHI00LA084Accident · No injuriesLimited investigationFinal reportCessna 150M · Marshall, MOthe go-around not performed, the improper flare, and recovery from a bounced landing not performed by the pilot. The crosswind was a contributing factor.Feb 27, 2000 · N462Q · Substantial damageNTSB CHI00LA079Accident · Serious injuriesLimited investigationFinal reportBeech BE-35V · Bloomington, INthe improper major overhaul of the engine by company maintenance personnel. The tree was a contributing factor.Feb 27, 2000 · N6FN · DestroyedNTSB MIA00LA098Accident · No injuriesLimited investigationFinal reportBell 412 · Karns, TNThe pilot's failure to maintain a visual lookout while repo sitioning the helicopter at a road side landing zone resulting in an in-flight (hover) collision with a tree.Feb 26, 2000 · N411UT · Substantial damageNTSB LAX00LA113Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Selma, CAThe failure and separation of the right landing gear axle during taxi from landing for undetermined reasons.Feb 26, 2000 · N1544K · Substantial damageNTSB FTW00LA088Accident · No injuriesLimited investigationFinal reportCessna 172K · Alpine, TXThe pilot's failure to maintain aircraft control during landing. A factor was the crosswind condition.Feb 26, 2000 · N46469 · Substantial damageNTSB FTW00LA087Accident · No injuriesLimited investigationFinal reportCessna 150L · Rush Springs, OKThe pilot's failure to maintain control of the aircraft during landing roll. Factors were the pilot's diverted attention to raising the flaps and the high wind conditions.Feb 26, 2000 · N1254Q · Substantial damageNTSB FTW00LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · New Ulm, TXThe pilot's failure to maintain clearance with a fence during the aborted landing.Feb 26, 2000 · N8967C · Substantial damageNTSB DEN00LA054Accident · No injuriesLimited investigationFinal reportMooney M-20C · Boulder, COThe pilot not following procedures in that he did not periodically clear the engine during an extended glide. The factors were carburetor icing, weather conditions conducive to carburetor ice, and lack of suitable terrain for landing.Feb 26, 2000 · N90MR · Substantial damageNTSB MIA00WA096Accident · 3 fatalForeign investigationCessna 210 · Puerto Barrios, GuatemalaFeb 25, 2000 · TGTRO · Substantial damageNTSB DEN00FA053Accident · 1 fatalField investigationFinal reportCessna 182E · El Prado, NMThe pilot's improper preflight planning/preparation in that he initiated flight into known adverse weather, and continued VFR flight into IMC to the point where remedial action was not possible. Factors were the weather conditions that included snow, low…Feb 25, 2000 · N2988Y · Destroyed