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 FTW96LA196Accident · No injuriesLimited investigationFinal reportBeech A35 · Siloam Springs, ARthe pilot's inadequate compensation for the crosswind. The crosswind was a factor.Apr 27, 1996 · N32P · Substantial damageNTSB FTW96LA190Accident · Serious injuriesLimited investigationFinal reportDeaton JUNGSTER-1 · Mcalester, OKthe pilot's failure to maintain obstacle clearance.Apr 27, 1996 · N57GD · DestroyedNTSB 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.Apr 27, 1996 · N8552T · DestroyedNTSB 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.Apr 27, 1996 · N20737 · DestroyedNTSB 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.Apr 27, 1996 · N7845C · DestroyedNTSB 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.Apr 27, 1996 · N9432T · Substantial damageNTSB 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…Apr 27, 1996 · N91304 · Substantial damageNTSB 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.Apr 27, 1996 · N2598P · Substantial damageNTSB 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…Apr 26, 1996 · N722PD · Substantial damageNTSB 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.Apr 26, 1996 · N700HC · DestroyedNTSB 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.Apr 26, 1996 · N2649C · Substantial damageNTSB 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.Apr 26, 1996 · N111PM · Substantial damageNTSB 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…Apr 26, 1996 · N2194Y · Substantial damageNTSB FTW96LA192Accident · No injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKthe student's inadvertent dynamic rollover, and inadequate supervision by the flight instructor.Apr 26, 1996 · N5226 · Substantial damageNTSB FTW96LA191Accident · No injuriesLimited investigationFinal reportCessna 172P · Denton, TXthe student pilot's delayed landing flare and his improper bounced landing recovery technique.Apr 26, 1996 · N5215K · Substantial damageNTSB 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.Apr 26, 1996 · N724YY · DestroyedNTSB 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.Apr 26, 1996 · N75839 · Substantial damageNTSB 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.Apr 26, 1996 · N4090X · Substantial damageNTSB 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.Apr 25, 1996 · N2001N · Substantial damageNTSB 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…Apr 25, 1996 · N2558W · DestroyedNTSB 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.Apr 25, 1996 · N18HZ · Substantial damageNTSB NYC96LA090Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Toms River, NJThe loss of engine power for undetermined reasons.Apr 24, 1996 · N602U · DestroyedNTSB 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.Apr 24, 1996 · N776FE · Substantial damageNTSB CHI96LA142Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Naperville, ILthe pilot allowed the airplane to become airborne prematurely, which resulted in a stall after liftoff.Apr 24, 1996 · N680V · Substantial damageNTSB 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…Apr 24, 1996 · N6254Z · DestroyedNTSB 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.Apr 24, 1996 · N4229H · Substantial damageNTSB MIA96WA129Accident · Minor injuriesForeign investigationCessna 182F · Grand Cayman, Cayman IslandsApr 23, 1996 · N3290U · DestroyedNTSB 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.Apr 23, 1996 · N333JS · Substantial damageNTSB 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,…Apr 23, 1996 · N9579F · DestroyedNTSB FTW96LA185Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Alice, TXthe student pilot's improper landing flare and improper bounced landing recovery.Apr 23, 1996 · N2537D · Substantial damageNTSB 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.Apr 23, 1996 · N68U · Substantial damageNTSB FTW96LA179Accident · No injuriesLimited investigationFinal reportCessna 172P · Colorado Spgs, COthe student pilot'S failure to maintain control of the aircraft during a go-around.Apr 23, 1996 · N55126 · Substantial damageNTSB 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.Apr 23, 1996 · N46748 · Substantial damageNTSB 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.Apr 22, 1996 · N8315R · Substantial damageNTSB 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.Apr 22, 1996 · N5144X · Substantial damageNTSB 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.Apr 22, 1996 · N8496N · Substantial damageNTSB 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.Apr 22, 1996 · N4883S · Substantial damageNTSB 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…Apr 21, 1996 · N8873S · Substantial damageNTSB 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.Apr 21, 1996 · N89414 · Substantial damageNTSB 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.Apr 21, 1996 · N231KS · Substantial damageNTSB 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.Apr 21, 1996 · N78LL · Substantial damageNTSB 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.Apr 21, 1996 · N8711V · DestroyedNTSB 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,…Apr 21, 1996 · N6542J · Substantial damageNTSB 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…Apr 21, 1996 · N739BN · Substantial damageNTSB ANC96LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Wasilla, AKthe pilot's delay in aborting the takeoff.Apr 21, 1996 · N8873J · Substantial damageNTSB 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…Apr 21, 1996 · N9704N · DestroyedNTSB NYC96LA092Accident · No injuriesLimited investigationFinal reportCessna 175 · Pittsfield, MAthe pilot's inadequate crosswind compensations during the landing roll.Apr 20, 1996 · N7002M · Substantial damageNTSB MIA96WA124Accident · No injuriesForeign investigationCessna C441 · Walkers Cay, BahamasApr 20, 1996 · N441W · Substantial damageNTSB 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…Apr 20, 1996 · N7VC · DestroyedNTSB FTW96LA176Accident · Serious injuriesLimited investigationFinal reportRaven S-66A · San Antonio, TXThe pilot's inadequate briefing of his passengers. A factor was the high wind.Apr 20, 1996 · N2814D · No damage