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 ANC96LA089Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nikiski, AKThe pilot's premature lift-off during the takeoff roll. The pilot's selection of unsuitable terrain for takeoff was a factor in the accident.NTSB SEA96LA125Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hillsboro, ORthe pilot's inadequate compensation for wind conditions, and his failure to attain a proper touchdown point for landing. A factor relating to the accident was: upsloping terrain short of the threshold.NTSB SEA96GA129Accident · Minor injuriesFinal reportCessna 182R · Grand View, IDfailure of the pilot to maintain clearance from mountainous terrain in a box canyon. The mountainous terrain and box canyon, limiting the pilot's ability to climb or maneuver and maintain sufficient altitude in the canyon, were related factors.NTSB NYC96LA128Accident · No injuriesLimited investigationFinal reportCessna 180 · Fulton, NYThe pilot's inadequate compensation for wind conditions.NTSB LAX96LA233Accident · 1 fatalLimited investigationFinal reportVan Horn Velocity · Goodyear, AZan engine compartment fire, which originated in flight from loose fuel and/or oil lines near the engine's firewall.NTSB IAD96LA096Accident · Minor injuriesLimited investigationFinal reportLittle Scamp · Worthington, KYwas the loss of engine power for undetermined reasons shortly after liftoff. A related factor was the unsuitable terrain encountered during the forced landing.NTSB FTW96LA254Accident · No injuriesLimited investigationFinal reportCessna 172H · Crockett, TXLoss of engine power for undetermined reason(s).NTSB FTW96LA251Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Cash, ARThe partial loss of engine power due to fuel contamination. A factor was the lack of suitable terrain available for the forced landing.NTSB FTW96LA249Accident · No injuriesLimited investigationFinal reportAmerican General AG-5B · Tulsa, OKthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel. Darkness was a related factor.NTSB FTW96FA250Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Monument, COThe pilot's VFR flight into instrument meteorological conditions in an aircraft which not instrument-equipped. Factors were clouds, low ceiling, and rain.NTSB CHI96WA204Accident · 1 fatalForeign investigationPiper PA-24-250 · Pelican Narrows, CanadaNTSB CHI96LA205Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Lambertville, MIa total loss of engine power as a result of fuel exhaustion due to the pilot's inadequate preflight, and the pilot's misjudged distance/altitude during the subsequent autorotation. A factor was inadequate maintenance and inspection.NTSB CHI96LA203Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Oslo, MNthe pilot not using carburetor heat when the engine began to lose power. Factors in this accident were carburetor ice formation and the soft landing surface the pilot had to use for landing.NTSB ATL96LA092Accident · No injuriesLimited investigationFinal reportCessna 411 · Rome, GAthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power in both engines, due to an inadequate supply of fuel.NTSB ANC96LA088Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Gustavus, AKA loss of engine power due to low fuel pressure from the engine driven fuel pump and subsequent fuel starvation. A factor was the lack of suitable terrain for a forced landing.NTSB SEA96LA127Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Aurora, ORinadvertent retraction of the landing gear by the pilot during landing.NTSB NYC96LA130Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Elbridge, NYThe pilot's improper decision to use auto fuel and to fly the airplane when it was in need of major repairs and overdue its annual inspection.NTSB NYC96FA126Accident · 3 fatalField investigationFinal reportPiper PA-23-150 · Cortland, NYthe pilot failure to maintain directional control of the airplane which resulted in the airplane striking trees. Contributing factors were the pilot's spatial disorientation, dark night conditions, fog, and the pilot's self induced pressure to reach the…NTSB LAX96LA245Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Las Vegas, NVthe pilot's inadvertent turn onto a vehicular access road instead of a taxiway at a large unfamiliar airport, and his diverted attention.NTSB LAX96LA231Accident · Serious injuriesLimited investigationFinal reportVans RV6 · Inyokern, CAthe pilot's failure to maintain control of his airplane and stalled while intentionally performing a low altitude maneuver on base leg in a high density altitude environment.NTSB LAX96LA230Accident · Minor injuriesLimited investigationFinal reportAyres S2R · Oracle, AZthe pilot's improper decision to turn toward rising terrain, without releasing or jettisoning the load of fire retardant, while maneuvering at slow airspeed, which resulted in a stall/mush and collision with the terrain. Factors relating to the accident were:…NTSB IAD96LA095Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Versailles, OHFuel exhaustion as a result of the pilot's inadequate fuel consumption calculations.NTSB FTW96LA256Accident · No injuriesLimited investigationFinal reportCessna R172K · Watkins, COan improper flare by the pilot, which resulted in a hard landing.NTSB CHI96LA206Accident · Serious injuriesLimited investigationFinal reportMitchell T Champabria · Kalamazoo, MIthe pilot's improper positioning of the throttle, while hand propping the aircraft engine, and his failure to either obtain proper assistance or properly secure the airplane.NTSB CHI96LA202Accident · No injuriesLimited investigationFinal reportPiper PA-44 · Grand Forks, NDthe instructor pilot used an improper procedure when he demonstrated a rejected takeoff and he misjudged the flare.NTSB CHI96IA207Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-320 · Boston, MAan undetermined intermittent fault in the trimmable horizontal stabilizer actuator system.NTSB CHI96IA200Incident · No injuriesIncident investigationFinal reportBoeing 727-30C · Chicago, ILlow pressure in the fuel lines caused when the crossfeed valve was closed and the boost pumps to the effected fuel tank were turned off, a fuel pressure surge (spike) accompanied by a rapid drop in high pressure pump output and burner line pressures, when…NTSB ATL96FA094Accident · 1 fatalField investigationFinal reportCessna 172N · Arlington, TNThe pilot's failure to maintain clearance above the trees. A factor was the dark night.NTSB NYC96LA124Accident · No injuriesLimited investigationFinal reportCessna 172 · Gardner, MAthe pilot 's misjudgment of speed and distance during landing.NTSB NYC96FA125Accident · 3 fatalField investigationFinal reportBeech V35 · Williamstown, NJinadequate supervision by the flight instructor (CFI); and failure of the pilot rated (dual) student to maintain control of the airplane during a simulated forced landing after takeoff, which resulted in a stall and collision with the terrain. Factors…NTSB LAX96FA229Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Big Bear City, CAimproper preflight by the pilot, by failing to ensure that the fuel selector was positioned to an approved fuel tank with adequate fuel before takeoff; his failure to reposition the fuel selector (per emergency procedures) after the loss of engine power; and…NTSB FTW96LA247Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Levelland, TXThe student pilot's improper use of mixture control resulting in a loss of engine power. A factor was the unsuitable terrain for the forced landing.NTSB CHI96LA199Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Charlotte, MIthe pilot's inadequate preflight planning and failure to use all the available runway for takeoff. Factors associated with the accident were the wet grass airstrip and the powerlines.NTSB NYC96LA127Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Fulton, NYthe student pilot's improper flare and the flight instructor's inadequate supervision.NTSB LAX96LA246Accident · No injuriesLimited investigationFinal reportCessna 172M · Sedona, AZthe pilot's improper recovery from a bounced landing. The variable/gusty/quartering tail wind was a related factor.NTSB LAX96LA225Accident · No injuriesLimited investigationFinal reportCessna 150H · Angels Camp, CAThe attempt by the pilot to operate the aircraft with a float known to be leaking. A factor was the pilot's lack of experience in the operation of float equipped aircraft.NTSB LAX96LA220Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Placerville, CAthe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain sufficient altitude to clear surrounding terrain. A factor was the pilot's intentional buzzing.NTSB FTW96LA246Accident · No injuriesLimited investigationFinal reportCessna 172N · Farmington, NMfailure of the pilot to maintain directional control during a touch-and-go landing, which resulted in a ground swerve and subsequent collision with a parked airplane.NTSB CHI96LA198Accident · No injuriesLimited investigationFinal reportPiper J-3 · Princeton, MNLoss of engine power for an undetermined reason.NTSB ATL96LA091Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Gulfport, MSimproper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel.NTSB SEA96LA119Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-150 · Bountiful, UTinadequate fuel management by the student pilot, which resulted in fuel starvation, due to an improperly positioned fuel selector. Factors relating to the accident were: the pilot's inadequate remedial action, and a ditch in the emergency landing area.NTSB FTW96LA245Accident · No injuriesLimited investigationFinal reportBeech 23 · Weiner, ARan improper flare by the pilot, which resulted in a hard landing.NTSB FTW96IA248Incident · No injuriesIncident investigationFinal reportFairchild SA227-DC · Enid, OKfailure of the accessory drive bearing, causing the accessory drive gear teeth to shear and disengage the fuel pump accessory drive shaft, resulting in a disabled fuel pump and subsequent fuel starvation.NTSB CHI96LA218Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Waterville, KSthe pilot's inadequate preflight procedure. Factors were fuel exhaustion, a leak in the fuel filtering system, and high vegetation.NTSB CHI96LA194Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Cleveland, NDfailure of the pilot to maintain sufficient altitude or clearance from trees during an aerial application operation. The wires and trees (obstructions) were related factors.NTSB CHI96LA193Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Lowell, MIwas inadequate initial training of the pilot and inadequate flight test procedures by the FAA Designated Pilot Examiner when he reportedly had the pilot demonstrate 12 pilot operations from the FAA's practical flight test standards in 35 minutes during the…NTSB ANC96TA087Accident · No injuriesFinal reportCessna 185F · Gustavus, AKThe pilot's inadequate compensation for the wind conditions. A factor associated with the accident was a crosswind.NTSB SEA96LA128Accident · 1 fatalLimited investigationFinal reportBailey Antares MA30 · Woodland, WAfailure of the uncertificated pilot to maintain adequate airspeed during the initial climb after takeoff, which resulted in a stall and collision with the terrain. The pilot's abrupt pull-up was a related factor.NTSB SEA96LA121Accident · No injuriesLimited investigationFinal reportBeech 35 · Aurora, ORfailure of the non-certificated pilot to ensure that the landing gear was properly extended for landing. The non-certificated pilot's diverted attention was a related factor.NTSB NYC96FA123Accident · 2 fatalField investigationFinal reportBeech E90 · Woolwich, MEfailure of the pilot to maintain control of the airplane while climbing after takeoff, due to spatial disorientation, which resulted in an uncontrolled descent and subsequent collision with terrain. Factors relating to the accident were: the improper…