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 MIA96LA234Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Wassau Island, GAthe pilot's inadequate preflight and planning which resulted in fuel exhaustion.Sep 27, 1996 · N151JP · Substantial damageNTSB MIA96FA233Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Birmingham, ALThe pilot-in-command's improper in-flight planning/decision for electing to continue the flight after observing that the fuel gauges indicated empty. Contributing to the accident was an improperly adjusted economizer jet and an out of adjustment float. Also…Sep 27, 1996 · N8803J · Substantial damageNTSB LAX96FA344Accident · Serious injuriesField investigationFinal reportThunder and Colt Colt 240A · Phoenix, AZThe pilot's impairment of judgment and performance due to drugs which led to his misjudgment of his descent rate during landing. Contributing factors were: his failure to activate the deflation device (rip line) and turn off the pilot lights, improper use of…Sep 27, 1996 · N434TC · Minor damageNTSB CHI96FA353Accident · 4 fatalField investigationFinal reportCessna 195 · Greenville, MOthe pilot's decision to fly into known adverse weather which resulted in an overload failure and separation of the left wing.Sep 26, 1996 · N195WR · DestroyedNTSB SEA96WA222Accident · No injuriesForeign investigationDouglas DC-3 · Holland, NetherlandsSep 25, 1996 · PHDDA · DestroyedNTSB SEA96LA223Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Paisley, ORTotal loss of engine power secondary to geartrain failure.Sep 25, 1996 · N8822W · Substantial damageNTSB SEA96LA220Accident · No injuriesLimited investigationFinal reportRalph Taylor Royal T · Kent, WAin-flight collision with an unknown object.Sep 25, 1996 · N2554 · Substantial damageNTSB NYC97LA084Accident · No injuriesLimited investigationFinal reportSchempp-Hirth CIRRUS-S · Wadsworth, OHThe pilot's inadvertent activation of the speed brakes while being towed for takeoff. Subsequently, the glider pilot lost sight of the tow airplane due to excessive altitude, released the tow rope, and performed an off airport landing during which the glider…Sep 25, 1996 · N9775 · Substantial damageNTSB IAD96LA154Accident · No injuriesLimited investigationFinal reportCessna 182 · Kansas, OHthe pilot's improper inflight planning/decision, which resulted in fuel exhaustion during cruise flight and subsequent loss of engine power. A related factor was the lack of suitable terrain for an emergency landing.Sep 25, 1996 · N6336A · Substantial damageNTSB IAD96LA153Accident · No injuriesLimited investigationFinal reportCessna 188 · Pataskala, OHdeterioration and fuel leakage from an engine fuel hose (with a service life that had been exceed, due to inadequate maintenance), which resulted in an engine compartment fire and subsequent damage to the airplane.Sep 25, 1996 · N3619J · Substantial damageNTSB FTW96LA401Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Falcon, COFailure by the pilot to select suitable terrain for landing. Factors were inadequate preflight planning and preparation for the flight by the pilot by failing to check NOTAMS and failing to use communication aids available to him.Sep 25, 1996 · N41369 · Substantial damageNTSB MIA96LA232Accident · 1 fatalLimited investigationFinal reportAir Tractor 402 · Slocomb, ALThe pilot's failure to maintain airspeed.Sep 24, 1996 · N9130M · DestroyedNTSB FTW96TA400Accident · No injuriesFinal reportCessna T188C · Snyder, TXThe pilot's failure to maintain clearance with a pole resulting in the separation of the left aileron and a loss of aircraft control. A factor was the haze.Sep 24, 1996 · N9537J · Substantial damageNTSB FTW96TA398Accident · Minor injuriesFinal reportHughes 269C · Houston, TXcompany maintenance personnel not complying with maintenance procedures and directives to inspect the helicopter's skids, which allowed the right skid to wear beyond the manufacturer's tolerances.Sep 24, 1996 · N7492F · Substantial damageNTSB CHI96LA347Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Fargo, NDthe pilot's failure to maintain directional control of the airplane during the landing. A factor was the crosswind.Sep 24, 1996 · N68ME · Substantial damageNTSB ANC96TA163Accident · Serious injuriesFinal reportde Havilland U-6A · King Salmon, AKfailure of the pilot to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an inadvertent stall and collision with the terrain (water). Turbulence was a related factor.Sep 24, 1996 · N67207 · Substantial damageNTSB ANC96LA164Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Aniak, AKThe pilot's failure to remove all snow and ice from the airplane prior to takeoff.Sep 24, 1996 · N5343G · Substantial damageNTSB ANC96FA162Accident · 3 fatalField investigationFinal reportCessna 206G · Anchorage, AKimproper installation of a connecting bolt in the throttle linkage, which resulted in a worn/disconnected throttle arm, partial loss of engine power, and a forced landing after takeoff.Sep 24, 1996 · N7312C · DestroyedNTSB SEA96LA219Accident · Minor injuriesLimited investigationFinal reportKaman HH-43 B/F · Troy, MTfailure of the freewheeling sprag unit bearings for undetermined reasons.Sep 23, 1996 · N4069R · Substantial damageNTSB IAD96LA151Accident · 1 fatalLimited investigationFinal reportCessna 150C · Liberty, KYthe pilot's failure to maintain adequate altitude, while maneuvering at a low altitude, which resulted in in-flight collision with trees.Sep 23, 1996 · N1947Z · DestroyedNTSB FTW96FA399Accident · 1 fatalField investigationFinal reportAyres S2R-T45 · Granger, TXthe pilot's inadvertent flight into adverse weather conditions, and subsequent loss of aircraft control due to spatial disorientation. Factors relating to the accident were darkness, the prevailing fog and low ceilings, the inadequate flight instruments…Sep 23, 1996 · N3107B · DestroyedNTSB CHI96LA343Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Minot, NDfuel management was not performed and starvation of the fuel system. A factor involved was inadequate in-flight planning/decision.Sep 23, 1996 · N1368Z · Substantial damageNTSB SEA96LA218Accident · No injuriesLimited investigationFinal reportCessna 170 · Enterprise, ORthe pilot's misjudgment of speed and distance during the approach/landing, his failure to attain a proper touchdown point during the landing, and his failure to go around (while there was sufficient runway remaining). The short runway was a related factor.Sep 22, 1996 · N2496D · Substantial damageNTSB SEA96LA217Accident · No injuriesLimited investigationFinal reportCessna 182P · Driggs, IDthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane, which resulted in an inadvertent ground swerve. Factors relating to the accident were: the gusty wind and soft terrain beside the runway.Sep 22, 1996 · N9017M · Substantial damageNTSB IAD96LA152Accident · No injuriesLimited investigationFinal reportCessna 182B · Hanover, PAthe pilot's improper planning/decision and failure to maintain clearance from obstacles during the landing roll. Related factors were: darkness, the lack of usable runway lights, and the road grading equipment parked 50 feet from the edge of the grass runway.Sep 22, 1996 · N2731G · Substantial damageNTSB FTW96LA396Accident · No injuriesLimited investigationFinal reportCoursey Prostar PT-2 · Rio Rancho, NMfatigue failure of the engine oil cooler coil, which resulted in an oil leak, oil starvation, loss of engine power, and a subsequent forced landing. Factors relating to the accident were: the proximity of a truck on the highway and soft terrain that was…Sep 22, 1996 · N822CF · Substantial damageNTSB CHI96LA350Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Germantown Hill, ILthe pilot's inadequate fuel supply and his misjudging distance and altitude. The trees were a factor.Sep 22, 1996 · N904SW · Substantial damageNTSB CHI96LA349Accident · Serious injuriesLimited investigationFinal reportAvian Balloon Magnum IX · Stilwell, KSthe pilot's not maintaining adequate clearance from a tree, and his allowing an abrupt touchdown. Factors relating to the accident were: dusk and the proximity of tree(s).Sep 22, 1996 · N2006W · No damageNTSB CHI96LA346Accident · No injuriesLimited investigationFinal reportBeech B23 · Viroqua, WIthe pilot's inadequate aircraft preflight which led to fuel exhaustion. A factor was the rough uneven terrain.Sep 22, 1996 · N66338 · Substantial damageNTSB CHI96LA344Accident · Minor injuriesLimited investigationFinal reportRozendaal Smith Innovation · Hampton, IAthe pilot's failure to refuel the airplane and his improper decision to perform a low altitude manuever with a low fuel supply.Sep 22, 1996 · N2982 · Substantial damageNTSB CHI96FA348Accident · 1 fatalField investigationFinal reportCessna 172F · Saint Clair, MNa loss of power due to the engine's #2 cylinder exhaust valve stuck open, and the pilot's failure to maintain airspeed.Sep 22, 1996 · N5373R · DestroyedNTSB NYC96LA186Accident · No injuriesLimited investigationFinal reportMooney M20K · Islip, NYloss of engine power for undetermined reason(s), which resulted in an emergency/wheels-up landing.Sep 21, 1996 · N3375X · Substantial damageNTSB LAX96LA342Accident · No injuriesLimited investigationFinal reportBell 206B · Van Nuys, CAthe pilot's improper in-flight planning/decision to turn right instead of left.Sep 21, 1996 · N909CM · Substantial damageNTSB LAX96LA341Accident · No injuriesLimited investigationFinal reportBeech V35A-TC · Santa Ynez, CAfailure of a maintenance technician to properly torque the fuel injector lines to three cylinders.Sep 21, 1996 · N7956M · Substantial damageNTSB LAX96FA340Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Caliente, CAimproper in-flight planning/decision by the flight instructor (CFI) by allowing the airplane to flying into a box canyon area, and his failure to maintain adequate airspeed, which resulted in an inadvertent stall and collision with wooded terrain. The CFI's…Sep 21, 1996 · N2393W · DestroyedNTSB LAX96FA339Accident · 1 fatalField investigationFinal reportCessna T207A · Littlefield, AZThe pilot's failure to maintain clearance with terrain during descent for undetermined reasons. Contributing factors were the dark night and mountainous terrain.Sep 21, 1996 · N6468H · DestroyedNTSB IAD96LA150Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Templeton, MAthe student pilot's improper in-flight decision to continued the cross-country flight into night conditions, and his inability to find the destination (or an alternate airport) in a timely manner, which resulted in fuel exhaustion, forced landing, and…Sep 21, 1996 · N2607J · DestroyedNTSB IAD96LA149Accident · No injuriesLimited investigationFinal reportCessna 172P · Richwood, WVimproper in-flight planning/decision by the flight crew, and inadequate supervision by the check pilot, which resulted in the flight crew's failure to maintain altitude/clearance from trees on rising terrain. A factor relating to the accident was:…Sep 21, 1996 · N848LF · Substantial damageNTSB FTW96LA397Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Lonestar, TXThe loss of engine power due to the pilot's improper fuel consumption calculations resulting in the fuel exhaustion. A factor was the unsuitable terrain for the forced landing.Sep 21, 1996 · N369PT · Substantial damageNTSB FTW96LA395Accident · Serious injuriesLimited investigationFinal reportBell 407 · Kerrville, TXThe loss of power due to the pilot's failure to comply with established procedures. Factors were a short in the FADEC wiring harness due to a manufacturing defect, and the lack of suitable terrain for the forced landing.Sep 21, 1996 · N1114S · Substantial damageNTSB FTW96LA393Accident · No injuriesLimited investigationFinal reportCessna 177RG · Boulder, COFailure of the flight instructor to maintain airspeed above stall speed during initial climb and loss of control on the ground after aborting the takeoff. Factors were inadequate preflight planning and preparation, inaccurate weather evaluation, and high…Sep 21, 1996 · N7568V · Substantial damageNTSB CHI96LA355Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Jordan, MNthe pilot's failure to maintain directional control during the landing roll.Sep 21, 1996 · N2505P · Substantial damageNTSB ATL96LA130Accident · 1 fatalLimited investigationFinal reportAir Tractor 402 · Mayersville, MSthe pilot's misjudgment of his ground speed and distance to trees during the swath run, and his delayed pull-up at the end of the swath run, which resulted in his failure to remain clear of the trees. The tail wind and location of the trees were related…Sep 21, 1996 · N1517G · Substantial damageNTSB ANC96LA167Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Noatak, AKThe pilot's selection of unsuitable terrain for landing.Sep 21, 1996 · N9366D · Substantial damageNTSB ANC96LA159Accident · No injuriesLimited investigationFinal reportPzl-Mielec 104-80 · Aniak, AKThe pilot's improper glide path on final approach, and his inadequate compensation for the gusty wind conditions. Factors associated with the accident are the gusty winds and a downdraft.Sep 21, 1996 · N6630M · Substantial damageNTSB ANC96FA161Accident · 1 fatalField investigationFinal reportPiper PA-18 · Minto, AKthe pilot's inadequate compensation for wind conditions, while maneuvering to land, which resulted in inadequate airspeed for conditions, an inadvertent stall, and collision with terrain (water).Sep 21, 1996 · N241WH · Substantial damageNTSB NYC96LA187Accident · No injuriesLimited investigationFinal reportCessna 180K · Derry, NHthe pilot's inadequate preflight inspection, which failed to detect water contaminated fuel, and resulted in a loss of engine power. A factor relating to the accident was: the pilot's operation of the aircraft with a known deficiency that consisted of a fuel…Sep 20, 1996 · N2738K · Substantial damageNTSB LAX96LA343Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Truckee, CAThe inadequate visual outlook by both pilots while in the vicinity of the airport. A factor was that each aircraft was on a different frequency at the time.Sep 20, 1996 · N840DC · 2 aircraft · Substantial damageNTSB FTW96LA394Accident · Serious injuriesLimited investigationFinal reportSaab-Scania SF-340B · Fort Smith, ARthe passenger fell for undetermined reasons, while disembarking from the airplane.Sep 20, 1996 · N320AE · No damageNTSB CHI96LA345Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kearney, MOthe pilot's improper use of carburetor heat, which resulted in a reduction of engine power and subsequent collision with the terrain, during a forced landing.Sep 20, 1996 · N25920 · Substantial damage