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 FTW96LA196Accident · No injuriesLimited investigationFinal reportBeech A35 · Siloam Springs, ARthe pilot's inadequate compensation for the crosswind. The crosswind was a factor.NTSB FTW96LA190Accident · Serious injuriesLimited investigationFinal reportDeaton JUNGSTER-1 · Mcalester, OKthe pilot's failure to maintain obstacle clearance.NTSB FTW96LA189Accident · Serious injuriesLimited investigationFinal reportCessna 182C · Malvern, ARfailure of the pilot to apply carburetor heat during the approach to land, which resulted in a loss of engine power due to carburetor ice. A factor relating to the accident was: the carburetor icing (weather) condition.NTSB FTW96LA188Accident · No injuriesLimited investigationFinal reportCessna 182P · Fordyce, ARthe pilot's failure to initiate a timely go-around. A factor was the pilot's misjudgment of distance and speed during the approach.NTSB FTW96FA183Accident · 4 fatalField investigationFinal reportPiper PA-28-151 · Vera, OKimproper installation by unknown person(s) of incorrect exhaust system clamps, which led to an exhaust system disconnect and a subsequent engine compartment fire.NTSB ATL96LA081Accident · No injuriesLimited investigationFinal reportCessna 210 · Knoxville, TNThe pilot's failure to heed known operating information by not correcting the flight attitude to prevent fuel unporting during a prolonged slipped descent.NTSB ANC96LA058Accident · No injuriesLimited investigationFinal reportCessna 180H · Palmer, AKThe pilot-in-command's inadvertent stall during the go around attempt. Factors in the accident were the pilot-in- command's lack of a high performance endorsement and the pilot/passenger's decision to allow the pilot-in-command to manipulate the controls…NTSB ANC96LA057Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKThe pilot's inadequate compensation for the wind conditions. A factor in the accident was the gusty wind conditions.NTSB MIA96LA131Accident · No injuriesLimited investigationFinal reportCessna 210M · Meridian, MSprevious engine damage; failure of the pilot of the previous flight to report to the operator and/or mechanics that the engine had been operated with low (or no) oil pressure; inadequate maintenance/inspection after most of the oil had leaked from the engine…NTSB MIA96FA130Accident · 1 fatalField investigationFinal reportHelio H-295 · Gaffney, SCfailure of the pilot to remove the control lock during the preflight, and his failure to check the flight controls before taking off.NTSB LAX96LA183Accident · No injuriesLimited investigationFinal reportCessna R182 · Las Vegas, NVthe pilot's misjudged landing flare and improper bounced landing recovery. Contributing factors were the overload failure of a main landing gear tire which resulted in the pilot's loss of directional control.NTSB IAD96LA067Accident · No injuriesLimited investigationFinal reportBell 206B · Logan, WVthe pilot's failure to maintain an adequate fuel supply for the flight which resulted in a loss of engine power due to fuel exhaustion, and the loss of rotor rpm during the autorotation. The downhill sloping terrain was a related factor.NTSB FTW96LA193Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Columbus, TXthe pilot's improper inflight planning/decision to continue the flight instead of returning to the takeoff airport after encountering adverse weather. Factors were: the inaccurate weather forecast, the low ceiling and the lack of suitable terrain for the…NTSB FTW96LA192Accident · No injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKthe student's inadvertent dynamic rollover, and inadequate supervision by the flight instructor.NTSB FTW96LA191Accident · No injuriesLimited investigationFinal reportCessna 172P · Denton, TXthe student pilot's delayed landing flare and his improper bounced landing recovery technique.NTSB FTW96LA184Accident · Minor injuriesLimited investigationFinal reportCessna T210M · El Paso, TXfailure of the #2 cylinder connecting rod bolt due to oil starvation as a result of the shifting of the main bearing. A factor was the unsuitable terrain for the forced landing.NTSB FTW96LA182Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COthe student pilot's inadequate compensation for wind conditions, and his failure to obtain/maintain directional control. A factor was the cross wind.NTSB ATL96LA082Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Mckenzie, TNThe pilot's improper use of the flight control during a crosswind landing that resulted in a loss of control of the airplane.NTSB NYC96LA091Accident · No injuriesLimited investigationFinal reportCessna 140 · Houlton, MEthe pilot's failure to select the fullest fuel tank prior to takeoff which resulted in fuel starvation during the initial takeoff climb.NTSB FTW96FA181Accident · 1 fatalField investigationFinal reportBeech A36 · Oklahoma City, OKthe pilot's delay in aborting the landing and his failure to obtain/maintain sufficient airspeed during the aborted landing, which resulted in an inadvertent stall and collision with the terrain. Factors relating to the accident were: the pilot's improper…NTSB CHI96LA143Accident · No injuriesLimited investigationFinal reportCessna 172 · Terre Haute, INthe pilot's improper planning/decision, which resulted in his inadequate compensation (or inability to compensate) for the wind condition. The high/gusty wind condition was a related factor.NTSB NYC96LA090Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Toms River, NJThe loss of engine power for undetermined reasons.NTSB IAD96LA066Accident · No injuriesLimited investigationFinal reportCessna 208 · Washington, DCThe pilot's failure to maintain control of the aircraft while taxiing for takeoff. Related factors were the wet runway and the gusty crosswind.NTSB CHI96LA142Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Naperville, ILthe pilot allowed the airplane to become airborne prematurely, which resulted in a stall after liftoff.NTSB CHI96FA141Accident · 1 fatalField investigationFinal reportPiper PA-25-150 · Buffalo, MOfailure of company/operator personnel to install the wing and landing gear (strut) fairings after modifying the airplane for a supplemental type certificate (STC), and improper planning/decision by the pilot. Factors relating to the accident were: the…NTSB ANC96LA056Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe pilot's inadequate compensation for crosswind conditions. Factors in the accident were the crosswind and the pilot's inadequate evaluation of the wind condition.NTSB MIA96WA129Accident · Minor injuriesForeign investigationCessna 182F · Grand Cayman, Cayman IslandsNTSB LAX96LA176Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Tucson, AZfailure of the pilot to adequately compensate for gusting crosswind conditions and to maintain directional control. A factor in the accident was unattended construction equipment parked in close proximity to the runway edge.NTSB LAX96FA177Accident · 1 fatalField investigationFinal reportHughes 269C · San Diego, CAthe decision of the pilot to fly at low altitude and low airspeed within a hazardous performance area published in the pilot operating handbook. Factors in the accident were tailwinds, lack of operator preventative maintenance impairing engine power,…NTSB FTW96LA185Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Alice, TXthe student pilot's improper landing flare and improper bounced landing recovery.NTSB FTW96LA180Accident · Minor injuriesLimited investigationFinal reportWhistle Questair Venture M20 · Watkins, COthe pilot's failure to compensate for prevailing wind conditions and to maintain directional control. Factors were the gusting and quartering tailwind conditions.NTSB FTW96LA179Accident · No injuriesLimited investigationFinal reportCessna 172P · Colorado Spgs, COthe student pilot'S failure to maintain control of the aircraft during a go-around.NTSB FTW96LA178Accident · No injuriesLimited investigationFinal reportCessna 152 · Bullard, TXfailure of an engine exhaust valve, which resulted in a loss of engine power, a forced landing, and subsequent damage to the airplane. Factors relating to the accident were: the tailwind, and the wet grass runway.NTSB MIA96TA127Accident · No injuriesFinal reportRobinson R-22 · Kissimmee, FLthe pilot's improper use of the helicopter's flight controls which led to an inadvertent loss of tail rotor effectiveness during a hover.NTSB MIA96LA125Accident · No injuriesLimited investigationFinal reportRans S6ES · Bayou La Batre, ALthe pilot's inadequate compensation for wind conditions. The gusty/crosswind condition was a related factor.NTSB CHI96LA144Accident · No injuriesLimited investigationFinal reportBeech B55B · Manhattan, KSthe pilot's failure to properly extend the landing gear. A factor was his failure to follow checklist procedures.NTSB CHI96LA137Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Aitkin, MNthe pilot's improper planning/decision, which resulted in his failure (or inability) to adequately compensation for wind conditions. Factors relating to the accident were: the gusty crosswind condition and the snowbank.NTSB SEA96LA082Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Salt Lake City, UTthe student pilot's inadequate preflight planning/preparation, by failuring to properly calculate the fuel consumption of the airplane, which led to fuel exhaustion and loss of power during cruise flight, due to an inadequate supply of fuel. A factor relating…NTSB NYC96LA089Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Greenville, NYThe pilot's failure to gain adequate airspeed due to inadequate planning in which he conducted a downwind takeoff, resulting in a stall mush, and collision with trees.NTSB NYC96LA087Accident · Serious injuriesLimited investigationFinal reportMooney M20K · West Milford, NJloss of engine power for undetermined reason(s), which resulted in a forced landing on unsuitable terrain and subsequent collision with trees.NTSB MIA96LA126Accident · No injuriesLimited investigationFinal reportLuttrell-Lacky Breezy · Hendersonville, NCinadequate preflight planning/preparation by the pilot, by not adequately surveying the area to be used for takeoff, which resulted in a collision with a fence.NTSB LAX96LA175Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Santa Barbara, CAThe pilot's failure to select a fuel tank containing an adequate quantity of fuel prior to landing, which resulted in fuel starvation.NTSB CHI96LA140Accident · No injuriesLimited investigationFinal reportCessna 172 · Dekalb, ILThe flight instructor's inadequate supervision, and his delay in taking remedial action to regain directional control of the airplane. Factors relating to the accident were: the student's improper flare for landing, improper recovery from a bounced landing,…NTSB CHI96LA136Accident · No injuriesLimited investigationFinal reportCessna 172N · Middleton, WIfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve. Factors relating to the accident were: the gusty crosswind condition, the pilot's excessive lowering of flaps, and the…NTSB ANC96LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Wasilla, AKthe pilot's delay in aborting the takeoff.NTSB ANC96LA053Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Grayling, AKdisintegration of the alternator drive coupling, jamming of the accessory drive gear, shearing of the oil pump drive, oil starvation, and failure of the number 6 cylinder connecting rod. Non-compliance with a manufacturer's service bulletin and soft snow were…NTSB NYC96LA092Accident · No injuriesLimited investigationFinal reportCessna 175 · Pittsfield, MAthe pilot's inadequate crosswind compensations during the landing roll.NTSB MIA96WA124Accident · No injuriesForeign investigationCessna C441 · Walkers Cay, BahamasNTSB MIA96LA123Accident · Serious injuriesLimited investigationFinal reportVernon L. Cox COX-HAWK · Mebane, NCThe pilot's inadvertent flight into instrument meteorological conditions in an airplane not equipped with appropriate instrumentation which led to the pilot's inability to maintain control and spatial disorientation. In addition, during an attemped recovery…NTSB FTW96LA176Accident · Serious injuriesLimited investigationFinal reportRaven S-66A · San Antonio, TXThe pilot's inadequate briefing of his passengers. A factor was the high wind.