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 MIA92FA121Accident · 3 fatalField investigationFinal reportCessna 310Q · Odessa, FLLoss of engine power on initial takeoff climb on all engines for undetermined reasons. This resulted in a forced landing, in flight collision with trees, terrain, and postcrash fire.May 3, 1992 · N300DG · DestroyedNTSB LAX92LA197Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Shelter Cove, CAThe complete loss of engine power for undetermined reasons.May 3, 1992 · N5468V · Substantial damageNTSB LAX92LA195Accident · No injuriesLimited investigationFinal reportBoeing PT-17 · Chino, CAThe pilot's failure to maintain directional control during the landing roll out.May 3, 1992 · N1731B · Substantial damageNTSB FTW92LA125Accident · Serious injuriesLimited investigationFinal reportShewmaker BD5 · Castroville, TXThe pilot's failure to maintain aircraft control during the flare. Factors were the engagement of the propeller feathering system and the pilot's total lack of experience in type aircraft and the slipped propeller pitch change system.May 3, 1992 · N68DS · DestroyedNTSB BFO92LA052Accident · Serious injuriesLimited investigationFinal reportBeech 24 · Millis, MAThe pilot's failure to attain adequate flying speed during takeoff climb which resulted in a stall and inflight collision with the terrain. Contributing was a downwind takeoff.May 3, 1992 · N2061L · Substantial damageNTSB BFO92FA051Accident · 2 fatalField investigationFinal reportSam R. Crowell SH-2R · Somerville, VAThe pilot's inadequate handling of aircraft during aerobatic maneuver which resulted in a loss of control. Contributing factors were lack of experience in operation.May 3, 1992 · N1RX · DestroyedNTSB ATL92LA094Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Wilmington, NCThe pilot's failure to obtain proper assistance during the engine starting procedure, and his failure to properly attend to the airplane with the engine running.May 3, 1992 · N72973 · Substantial damageNTSB ANC92LA067Accident · No injuriesLimited investigationFinal reportCessna C-A185F · Barrow, AKThe improper use of the flt controls by the second pilot during landing roll. Factors relating to the mishap were the rough/uneven snow covered terrain.May 3, 1992 · N20752 · Substantial damageNTSB SEA92LA087Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Prineville, ORThe pilot in command delaying his decision to divert for fuel, overloading of the nose gear strut and the pilot in command's inability to maintain aircraft control subsequent to the nose wheel separation. Factors contributing to the accident were: the pilot…May 2, 1992 · N5469V · Substantial damageNTSB LAX92LA386Accident · 1 fatalLimited investigationFinal reportBeech A36 · Avalon, CAA loss of control due to pilot incapacitation for an undetermined reason(s).May 2, 1992 · N583T · DestroyedNTSB LAX92LA194Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-325 · Independence, CAFuel starvation due to 1) the pilots inadequate preflight planning preparation, 2) the pilot's fuel system management, and 3) his operation of the aircraft with known deficiencies in the aircraft electrical system. Factors in the accident were: 1) the…May 2, 1992 · N59781 · DestroyedNTSB LAX92FA196Accident · 2 fatalField investigationFinal reportBeech A23-24 · Corona, CA1) The flying pilot's improper landing flare which resulted in a hard landing and significant damage to the aircraft empennage flight controls, 2) the flying pilot's decision to initiate a go around with the obvious serious damage to the aircraft, and 3) the…May 2, 1992 · N666CM · DestroyedNTSB FTW92LA124Accident · No injuriesLimited investigationFinal reportCessna 172M · Canton, TXThe pilot's failure to maintain adequate airspeed and directional control during the attempted go around following an encounter with adverse wind conditions on approach.May 2, 1992 · N9623V · Substantial damageNTSB CHI92LA139Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140D · Markham, ILThe result of an inadequate annual inspection by other maintenance personnel and, as a result, a total failure of the throttle linkage. A factor was the pilot overshot his intended emergency landing area, due to excessive speed.May 2, 1992 · N1814T · Substantial damageNTSB ATL92LA093Accident · 1 fatalLimited investigationFinal reportSchreder RS-15 · Benton, TNThe pilot's misjudged approach to the open field, which resulted in the forced landing on the obstacle lined road.May 2, 1992 · N17TM · Substantial damageNTSB SEA92LA088Accident · No injuriesLimited investigationFinal reportHughes 369E · Hillsboro, ORThe pilot in command's excessive application of collective.May 1, 1992 · N5211Y · Substantial damageNTSB BFO92LA054Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · South Boston, VAThe pilot failed to maintain obstacle clearance which resulted in inflight collision with a powerline.May 1, 1992 · N1837G · Substantial damageNTSB BFO92LA053Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Amelia, VAThe pilot's misjudgement of distance and altitude that resulted in an landing overrun and collision with an embankment. Contributing was failure to initiate a go around and inadequate supervision.May 1, 1992 · N20209 · DestroyedNTSB ATL92LA092Accident · No injuriesLimited investigationFinal reportCessna 172E · Concord, NCThe loss of engine power because of the formation of carburetor ice.May 1, 1992 · N5529T · Substantial damageNTSB SEA92LA086Accident · No injuriesLimited investigationFinal reportCessna 182B · Dixie, IDThe pilot's inadequate compensation for the wind conditions. Factors relating to the accident were the high density attitude and the downdraft.Apr 30, 1992 · N8409T · Substantial damageNTSB NYC92GA089Accident · No injuriesFinal reportMcdonnell Douglas 500E · Mount Zion, KYAn in-flight separation of the tail rotor assembly as the result of the loss of an abrasion strip from the leading edge of one of the tail rotor blades, which induced vibrational stresses high enough to initiate fatigue failure in the tail rotor gear box…Apr 30, 1992 · N97BR · Substantial damageNTSB LAX92LA193Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A · Coolidge, AZThe pilot's use of unsuitable terrain and inadequate compensation for the existing wind conditions.Apr 30, 1992 · N1360C · Substantial damageNTSB FTW92LA123Accident · Serious injuriesLimited investigationFinal reportGrumman G164 · Bayside, TXThe pilot's inadequate visual lookout.Apr 30, 1992 · N468RF · DestroyedNTSB DEN92LA049Accident · Minor injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Montrose, COFailure of the pilot in command to maintain control of the aircraft during landing roll. A factor was: the aircraft struck a ditch which ran parallel to the runway.Apr 30, 1992 · N45033 · Substantial damageNTSB CHI92LA137Accident · Serious injuriesLimited investigationFinal reportBell 47-G2A · Dousman, WIThe in-flight loss of the swash plate drive link bolt which allowed the swash plate drive assembly to disconnect.Apr 30, 1992 · N52HB · Substantial damageNTSB CHI92DCJ03Accident · No injuriesFinal reportSchweizer G-164B · Scotia, NEThe pilot's failure to maintain aircraft control which resulted in a nose over during the precautionary landing. Related factors are the power lines (obstructions) and inadequate altitude.Apr 30, 1992 · N31GW · Substantial damageNTSB SEA92LA085Accident · No injuriesLimited investigationFinal reportCessna 150G · Caldwell, IDThe pilot in command's failure to maintain directional control. Factors contributing to the accident were: crosswinds and gusts.Apr 29, 1992 · N3218J · Substantial damageNTSB MIA92WA119Accident · 1 fatalForeign investigationPiper PA-32-300 · San Michele, HaitiApr 29, 1992 · N4026W · DestroyedNTSB MIA92LA120Accident · No injuriesLimited investigationFinal reportBeech C35 · Scottsmoor, FLEncounter with clear air turbulence during cruise flight.Apr 29, 1992 · N657D · Substantial damageNTSB CHI92LA138Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Sioux Falls, SDThe pilot-in-command's failure to maintain directional control.Apr 29, 1992 · N87020 · Substantial damageNTSB CHI92DCD03Accident · Minor injuriesFinal reportPiper PA-36-375 · Deloit, IAInadequate visual lookout by the pilot in command while performing aerial application maneuvers. A factor in the accident is the pilot's diverted attention.Apr 29, 1992 · N3986E · Substantial damageNTSB BFO92FA050Accident · 1 fatalField investigationFinal reportMooney M20E · Adamstown, MDFailure of the pilot to maintain control of the airplane.Apr 29, 1992 · N3357X · DestroyedNTSB NYC92LA088Accident · No injuriesLimited investigationFinal reportWishon Baby Great Lakes · Ottawa, OHA hard landing due to inadequate flare by the pilot. Factors related to the accident were the inadequate transition training the pilot received and his lack of total experience.Apr 28, 1992 · N1035Q · Substantial damageNTSB NYC92LA080Accident · No injuriesLimited investigationFinal reportCessna 180 · Winfield, WVThe improper in-flight planning and decision of the pilot to land on the strip and the pilot's delay in attempting the go-around. Factors in this accident were: the pilot was unable to maintain control of the aircraft due to the wet grass and the tail wind.Apr 28, 1992 · N9207C · Substantial damageNTSB FTW92LA121Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Houston, TXThe failure of the hydraulic system seal and the subsequent fluid leak.Apr 28, 1992 · N140RD · Substantial damageNTSB DEN92LA047Accident · No injuriesLimited investigationFinal reportCessna 172RG · Elbert, COFailure of the crankshaft left accessory gear which resulted in a complete power loss. A factor was: lack of suitable terrain for a forced landing.Apr 28, 1992 · N5282V · Substantial damageNTSB CHI92LA140Accident · No injuriesLimited investigationFinal reportBell BH47G · Bucklin, MOThe helicopter pilot's abrupt touchdown during the forced landing. Related factors were the presence of carburetor ice conditions, and the pilot's improper use of carburetor heat.Apr 28, 1992 · N90642 · Substantial damageNTSB CHI92LA136Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Grain Valley, MOA stall following a downwind takeoff.Apr 28, 1992 · N77205 · Substantial damageNTSB ANC92LA065Accident · Minor injuriesLimited investigationFinal reportBell B206 II · Valdez, AKThe pilot's failure to follow the company procedures and directives. Factor was the whiteout conditions.Apr 28, 1992 · N371EH · Substantial damageNTSB CHI92LA134Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · La Crosse, WIVisual lookout inadequate and diverted attention by the pilot. A factor related to the accident was transmission wires crossing flight path.Apr 27, 1992 · N53988 · Substantial damageNTSB CHI92DCQ02Accident · Serious injuriesFinal reportLarry E. Medlin Challenger II SPEC. · Maize, KSFailure of the pilot to maintain an airspeed above stalling speed while turning from base leg to final approach. Factors in the accident are the pilot's lack of total and recent aviation experience.Apr 27, 1992 · N4268R · Substantial damageNTSB SEA92LA084Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Grants Pass, ORA failure to maintain runway alignment, and a delayed go-around. Factors include a crosswind, gusts, and a fence in the go-around path.Apr 26, 1992 · N9403E · Substantial damageNTSB MIA92WA116Accident · 1 fatalForeign investigationPiper PA-23-250 · Marsh Harbour, BahamasApr 26, 1992 · N5611Y · Substantial damageNTSB MIA92LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Brooksville, FLThe pilot's inadequate compensation for wind conditions during the landing flare, in gusty winds.Apr 26, 1992 · N2335K · Substantial damageNTSB MIA92FA118Accident · Serious injuriesField investigationFinal reportCessna 172RG · Cedar Key, FLImproper recovery from the bounced landing by the pilot-in-command, and failure to maintain directional control. Contributing to the accident was the crosswind.Apr 26, 1992 · N9888B · Substantial damageNTSB LAX92LA192Accident · No injuriesLimited investigationFinal reportLaister Nugget · Bishop, CAThe pilot-in-command's improperly planned no-flap landing approach; failure to follow the checklist; and inadvertent gear retraction. Factors contributing to the accident were the buckling of the wing skin, cracking of the fuselage and the inoperative flaps.Apr 26, 1992 · N97DT · Substantial damageNTSB LAX92LA191Accident · No injuriesLimited investigationFinal reportBeech V35B · Hesperia, CAThe pilot's inadequate compensation for the existing wind conditions. Contributing to this accident was the downdraft.Apr 26, 1992 · N14WK · Substantial damageNTSB LAX92LA190Accident · No injuriesLimited investigationFinal reportCessna 177RG · Mammoth Lakes, CAThe pilot-in-command's inaccurate weather evaluation, his improper setting of the mixture control, and his failure to maintain proper climb airspeed. Factors related to the accident were: high density altitude, unfavorable wind with mountain wave activity and…Apr 26, 1992 · N33248 · Substantial damageNTSB LAX92LA189Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Vallejo, CAWas the failure of the fuel servo diaphragm stem which resulted in a fuel interruption to the engine. High obstructions and utility pole in the forced landing area were factors contributing to the accident.Apr 26, 1992 · N31557 · Substantial damageNTSB LAX92FA188Accident · 3 fatalField investigationFinal reportBeech 35 · Reno, NVThe pilot's poorly planned approach to compensate for the existing wind conditions, and his failure to maintain adequate airspeed.Apr 26, 1992 · N3121V · Destroyed