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 MIA97LA150Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Key Largo, FLthe pilot's failure to maintain directional control during a crosswind landing, which resulted in an inadvertent ground swerve and collision with bushes and terrain.NTSB LAX97LA169Accident · No injuriesLimited investigationFinal reportCameron N-77 · Temecula, CAThe pilot's misjudgment of his speed and altitude, which led to a landing overshoot.NTSB FTW97LA172Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Canon City, COThe pilot's failure to maintain an adequate visual lookout. A factor was the pilot's attention being diverted.NTSB DCA97WA043Accident · No injuriesForeign investigationMcDonnell Douglas MD-82 · Jinan, ChinaNTSB CHI97LA118Accident · No injuriesLimited investigationFinal reportHughes 269A · Council Bluffs, IAfailure of the student pilot to maintain directional control, inadequate supervision by the flight instructor (CFI), and subsequent failure of the pilot(s) to properly flare the helicopter during a hover autorotation.NTSB CHI97LA115Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Duluth, MNthe loss of engine power for undetermined reasons and the pilot's failure to maintain aircraft control.NTSB CHI97LA114Accident · Serious injuriesLimited investigationFinal reportOlsen Acro Sport II · Monon, INThe loss of engine power for undetermined reasons. Low altitude flight is a contributing factor.NTSB SEA97LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Rawlins, WYThe pilot's inadequate preflight planning. Factors include high density altitude, downdrafts, and rough/uneven terrain in the area where the pilot attempted the emergency landing.NTSB SEA97LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Ilwaco, WAThe student pilot's failure to land the aircraft at the proper touchdown point. Factors include inadequate preflight planning/preparation by the student pilot, inadequate supervision by the student pilot's flight instructor, rain, fog, strong crosswinds, a…NTSB LAX97LA168Accident · Serious injuriesLimited investigationFinal reportCessna T182 · Hemet, CAthe pilot's decision not to dip check the aircraft fuel tanks after he had noted a disagreement between the cockpit fuel gages and what he had observed visually in the fuel tanks, and his failure to accomplish in-flight endurance calculations based on…NTSB FTW97FA171Accident · 3 fatalField investigationFinal reportPiper PA-32RT-300T · Rye, COThe pilot initiating flight into IMC conditions in mountainous terrain. Factors were mountainous terrain, low ceiling, snow, preflight planning, and in-flight planning and decision making.NTSB CHI97FA116Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Holland, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent impact with trees and then a residence. A related factor was turbulence.NTSB ATL97LA063Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Lincolnton, GAThe pilot's inadequate preflight planning of the fuel requirement for this flight that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB ANC97LA069Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Selawik, AKThe pilot's failure to extend the landing gear. A factor associated with the accident was the pilot's diverted attention while in the landing pattern.NTSB LAX97LA167Accident · Serious injuriesLimited investigationFinal reportCessna 172P · San Jose, CAThe student pilot's failure to maintain adequate airspeed to preclude stalling following an improper recovery from a bounced landing. Contributing factors were the pilot's premature and excessive flap retraction and misjudged landing flare.NTSB ATL97LA062Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Clearwater, FLThe pilot's failure to select the fuller tank for takeoff that resulted in fuel starvation to the engine, and the subsequent total loss of engine power.NTSB MIA97LA149Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Huntersville, NCThe pilot's failure to maintain a visual lookout on landing rollout, resulting in an on-ground collision with a known obstacle (ditch) and subsequent nose over.NTSB MIA97LA148Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tampa, FLloss of engine for undetermined reason(s), which resulted in a forced landing and subsequent collision with a fence.NTSB LAX97LA166Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZthe pilot's encounter with crosswind gusts beyond the performance capability of the aircraft. A lack of crosswind limit information published in the Cessna 172N Pilot's Operating Handbook for landing and taxiing operations is a factor in the accident.NTSB CHI97LA113Accident · No injuriesLimited investigationFinal reportCessna 185 · Pella, IAthe pilot's selection of an unsuitable area for the landing. A factor relating to the accident was: the soft landing surface of the farm strip.NTSB MIA97LA145Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Augusta, GAflight by the pilot into known adverse weather conditions, which resulted in a loss of aircraft control during the landing flare, and collision with the terrain. The adverse weather with nearby thunderstorm activity, crosswind, and gusts was a related factor.NTSB FTW97TA165Accident · Minor injuriesFinal reportBell 206-L1 · Trinidad, COThe pilot's failure to maintain control of the helicopter due to a loss of tail rotor effectiveness. A factor was the tailwind condition and the pilot's failure to maintain proper airspeed.NTSB FTW97LA178Accident · Serious injuriesLimited investigationFinal reportRans S-12 · Goldsby, OKthe pilot-in-command's improper judgment in allowing the passenger to control the airplane, and the pilot-in-command's inadequate supervision. Factors relating to the accident were: the passenger's failure to maintain minimum required airspeed, which resulted…NTSB FTW97FA166Accident · 1 fatalField investigationFinal reportSocata TB-20 · Pagosa Springs, COinadvertent flight by the pilot into known adverse weather conditions, and his failure to maintain altitude or clearance from terrain. Factors relating to the accident were: low ceiling, rain, snow, icing conditions, and mountainous terrain.NTSB ANC97LA075Accident · No injuriesLimited investigationFinal reportCessna 207A · Minto, AKThe pilot's inadequate preflight inspection of the airplane, which resulted in an unlatched door opening in-flight.NTSB NYC97LA079Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Lehighton, PAreplacement of the flap actuating system fuse by the pilot-in-command with the flap actuating handle in the fully retracted position. This resulted in the retraction of the flaps, an inadvertent stall/mush, and the subsequent in-flight collision with terrain.NTSB CHI97LA110Accident · Serious injuriesLimited investigationFinal reportGulfstream 500B · Mission, KSthe pilot's inadequate preflight planning which resulted in fuel exhaustion.NTSB ANC97LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Ninilchik, AKfailure of the pilot to maintain altitude/clearance from a closed runway, while making a low pass, which resulted in an inadvertent touchdown.NTSB MIA97LA146Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ackerman, MSinstallation of an incorrect fuel filter in the fuel tanker, which allowed water-contaminated fuel being dispensed into the aircraft, subsequent partial loss of engine power on initial takeoff climb, and a forced landing. The lack of suitable terrain for a…NTSB FTW97LA164Accident · No injuriesLimited investigationFinal reportCessna 150F · Norman, OKImproper flare.NTSB FTW97LA163Accident · No injuriesLimited investigationFinal reportCessna 172P · Mckinney, TXthe student pilot's failure to maintain directional control on the ground after recovery from a bounced landing.NTSB CHI97LA109Accident · No injuriesLimited investigationFinal reportCessna 421C · Pierre, SDthe pilot's inadvertent activation of the number one throttle/power control. Factors were: the pilot left the cockpit unattended with the engines running and a wet ramp.NTSB CHI97FAMS2Accident · 2 fatalMissing aircraftFinal reportBeech 95-C55 · Grand Haven, MIundetermined.NTSB ATL97IA061Incident · No injuriesIncident investigationFinal reportBritish Aerospace 125-800A · Chamblee, GAphysical impairmant of the captain during flight, which was the resulted of a kidney stone.NTSB ANC97LA060Accident · No injuriesLimited investigationFinal reportCessna 180K · Soldotna, AKthe pilot's inadequate compensation for cross conditions and failure to maintain directional control of the airplane. A factor relating to the accident was: the variable/gusty/crosswind condition.NTSB MIA97FA142Accident · 2 fatalField investigationFinal reportBoeing Stearman N2S-4 · Apex, NCThe pilot-in-command's ostentatious display by performing an aerobatic maneuver with inadequate altitude.NTSB IAD97LA068Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wellsville, NYthe student pilot's improper flare, improper recovery from a bounced landing, and loss of directional control, during the landing.NTSB IAD97FA065Accident · 2 fatalField investigationFinal reportLockheed PV2 · Blandburg, PAPilot in command misjudged his maneuvering altitude. Factors to this accident were the mountainous terrain, windy conditions, turbulence in the area, and smoke.NTSB FTW97IA161Incident · No injuriesIncident investigationFinal reportBoeing 747-300 · Houston, TXThe first officer's failure to maintain clearance while taxiing around a standing airplane.NTSB CHI97LA108Accident · Serious injuriesLimited investigationFinal reportAerostar RXS-8 · Sioux Falls, SDthe ground crewmember failed to maintain visual contact with the balloon, while it was landing. A factor relating to the accident was: the ground crewmember allowed her attention to be diverted while keeping a child out of harms way.NTSB SEA97LA091Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · West Jordan, UTlanding gear collapsed for undetermined reasons.NTSB SEA97LA089Accident · 1 fatalLimited investigationFinal reportIvan Langston Hawk · Howell, UTThe pilot's failure to maintain control of the aircraft. Heavy rain and gusting winds were a factor.NTSB MIA97LA144Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Smithfield, NCa fracture in the crankshaft, which resulted in a total loss of engine power, a forced landing, and a nose over.NTSB MIA97LA143Accident · No injuriesLimited investigationFinal reportCessna 150G · Raleigh, NCfailure of the pilot to maintain proper runway alignment during the attempted landing and go-around. Factors relating to the accident were: the gusty crosswind condition, and proximity of trees to the runway.NTSB MIA97LA141Accident · 1 fatalLimited investigationFinal reportYoung Merlin GT · Fort Myers, FLthe pilot's failure to maintain airspeed during the initial climb after takeoff, which resulted in an inadvertent stall/spin and subsequent collision with the terrain. Factors relating to the accident were: the pilot's failure to use all available runway, and…NTSB MIA97IA147Incident · No injuriesIncident investigationFinal reportBoeing 747-2R7F · Miami, FLdisbonding and separation of the right inboard wing fixed trailing edge panel during cruise flight, which resulted in damage to the inboard fore flap and inboard mid flap, and a subsequent precautionary landing at the departure airport.NTSB LAX97LA165Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · Hemet, CAthe pilot's failure to adjust his traffic pattern to compensate for local atmospheric conditions.NTSB LAX97FA164Accident · Serious injuriesField investigationFinal reportBoeing 737-3S3 · Las Vegas, NVinadequate service provided by the TRACON controller, by issuing a radar vector to the Boeing 737 flight, which resulted in inadequate separation from a Beech 99 that the controller had just terminated from radar service; and failure of the controller to…NTSB FTW97LA169Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Fluvanna, TXThe loss of engine power due to the failure of the reduction gear box. A factor was the lack of suitable terrain for the forced landing.NTSB CHI97LA111Accident · No injuriesLimited investigationFinal reportCessna 177 · Rantoul, ILthe student pilot's improper flare and improper recovery from a bounced landing.