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 CHI91LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pinconning, MIInadequate airspeed, wind shear and a stall.Jan 1, 1991 · N5063T · Substantial damageNTSB CHI91LA054Accident · No injuriesLimited investigationFinal reportCessna 172P · New Holstein, WIThe pilot's decision to continue the landing approach, landing on an ice covered runway and the inadequate compensation for the croswind.Jan 1, 1991 · N55409 · Substantial damageNTSB SEA91LA040Accident · No injuriesLimited investigationFinal reportSwearingen SA-227 · Kalispell, MTThe flight crew's inablity to maintain directional control after landing in snow-depth conditions that had been erroneously reported as being within operating limitations.Dec 31, 1990 · N385PH · Substantial damageNTSB SEA91FA038Accident · 2 fatalField investigationFinal reportCessna 182B · Estacada, ORA power loss due to carburetor ice, and missing muffler cones as a result of inadequate maintenance inspection. In addition, the pilot failed to maintain adequate airspeed during the forced landing which resulted in a stall.Dec 31, 1990 · N7288E · Substantial damageNTSB MIA91IA059Incident · No injuriesIncident investigationFinal reportCessna 402C · Marathon, FLFatigue failure of a nose landing gear drag brace assembly which caused the nose landing gear to collapse during the landing roll. Contributing to the accident was an inadequate inspection of the airplane approximately 7 hours earlier by company maintenance…Dec 31, 1990 · N155PB · Minor damageNTSB LAX91LA063Accident · No injuriesLimited investigationFinal reportCessna 172 · Tucson, AZBoth pilots used poor visual lookout procedures.Dec 30, 1990 · N739ZV · 2 aircraft · Substantial damageNTSB BFO91LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Mitchellville, MDPilot failure to maintain altitude clearance above an obstacle after the aircraft encountered a downdraft.Dec 30, 1990 · N6945J · Substantial damageNTSB ATL91FA035Accident · 1 fatalField investigationFinal reportBeech B95 · Austell, GAThe loss of engine power which resulted from the pilot's failure to properly use the carburetor heat. The pilot failed to maintain flying speed during the emergency descent which resulted in a stall on final approach. A factor in the accident was weather…Dec 30, 1990 · N2794Y · DestroyedNTSB ATL91FA031Accident · 1 fatalField investigationFinal reportCessna 182E · Saluda, NCThe continued visual flight rules flight into instrument meteorological conditions. Contributing factor were fog, rain, and low ceiling.Dec 30, 1990 · N9383X · DestroyedNTSB MIA91FA058Accident · Serious injuriesField investigationFinal reportCessna 310 · New Smyrna Bch, FLThe pilot-in-command/mechanic reversal of the aileron control cables on the sprocket during installation. This resulted in an in flight loss of control on takeoff, uncontrolled descent, and in flight collision with terrain.Dec 29, 1990 · N4808B · DestroyedNTSB DEN91LA029Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Aspen, COFuel exhaustion induced power loss resultant from faulty fuel caps and fuel syphoning.Dec 29, 1990 · N1604U · Substantial damageNTSB NYC91IA053Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Elbridge, NYThe failure of the pilot to conduct a proper preflight inspection of the fuel tanks, and a misreading fuel gauge which resulted in a double power loss.Dec 28, 1990 · N8434H · Minor damageNTSB MIA91WA056Accident · Minor injuriesForeign investigationPiper PA-31-350 · Rock Sound, BahamasDec 28, 1990 · N141RA · DestroyedNTSB MIA91FA057Accident · 1 fatalField investigationFinal reportMooney M20C · Pensacola, FLThe pilot's failure to use carburetor heat resulting in loss of engine power due to carburetor ice. A factor in the accident was the pilot's medical condition.Dec 28, 1990 · N6600U · DestroyedNTSB LAX91LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Sierra Vista, AZLoss of engine power due to carburetor ice from improper use of the carburetor heat control.Dec 28, 1990 · N5968W · Substantial damageNTSB CHI91LA052Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · St. Ignace, MIThe deer crossing the runway which the pilot was unable to avoid.Dec 28, 1990 · N33797 · Substantial damageNTSB SEA91LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe certified flight instructor's inability to regain directional control after it was lost by his dual student on an icy, snowy runway.Dec 27, 1990 · N5133B · Substantial damageNTSB MIA91WA055Accident · No injuriesForeign investigationPiper PA-34-200 · Nassau, BahamasDec 27, 1990 · N15047 · Substantial damageNTSB CHI91FA053Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Gardner, KSA loss of engine power for undetermined reasons. Darkness was a related factor.Dec 27, 1990 · N84499 · Substantial damageNTSB BFO91LA021Accident · Minor injuriesLimited investigationFinal reportCessna 152 · South Boston, VAThe student pilot's delay in taking appropriate action while encountering adverse weather conditions. Factors which contributed to the accident were: the weather conditions that were worse than forecast, and the unsuitable terrain.Dec 27, 1990 · N48918 · DestroyedNTSB NYC91DGT01Accident · 1 fatalFinal reportKolb Twin Star · Carlisle, PAThe pilot's failure to maintain adequate altitude above the ground.Dec 26, 1990 · UNREG · Substantial damageNTSB MIA91WA054Accident · Serious injuriesForeign investigationCessna 401B · Marsh Harbor, BahamasDec 26, 1990 · N799NW · DestroyedNTSB LAX91LA060Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Yucca Valley, CAThe pilot's improper use of the flaps. Contributing to this accident was the loss of control during tailwind landing, and his tailwind and the pilot's inadequate inflight planning.Dec 26, 1990 · N5258D · Substantial damageNTSB CHI91LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Plymouth, MIThe pilot-in-command (CFI)'s inadequate supervision of the dual student.Dec 26, 1990 · N67401 · Substantial damageNTSB CHI91LA048Accident · No injuriesLimited investigationFinal reportHughes 269A · Sellersburg, INA pilot induced loss of engine power by inadvertent deactivation of the fuel mixture control.Dec 26, 1990 · N90270 · Substantial damageNTSB BFO91LA020Accident · No injuriesLimited investigationFinal reportCessna 402 · Richland, VAFailure of the left main landing gear scissor assembly.Dec 26, 1990 · N8138F · Substantial damageNTSB ATL91LA033Accident · No injuriesLimited investigationFinal reportCessna 310Q · Windsor, SCFailure of the owner of the private sod airport to properly maintain the runway, which precipitated the loss of control of the airplane during the landing roll.Dec 26, 1990 · N2251Q · Substantial damageNTSB FTW91LA026Accident · No injuriesLimited investigationFinal reportCessna 205 · Medford, OKThe pilot's use of improper starting procedures which resulted in the loss of control of the airplane. A factor in the accident was the airplane's encounter with rough terrain during the unmanned taxi.Dec 25, 1990 · N8219Z · Substantial damageNTSB CHI91LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Lee'S Summit, MOThe pilot's inability to maintain directional control of the airplane after landing. The icy runway and the pilot's lack to total experience were factors.Dec 24, 1990 · N4977P · Substantial damageNTSB MIA91LA052Accident · Serious injuriesLimited investigationFinal reportAeronca L-3C · Brooksville, FLTotal loss of engine power due to undetermined reasons.Dec 23, 1990 · N52350 · Substantial damageNTSB MIA91IA051Incident · No injuriesIncident investigationFinal reportDassault-Breguet HU-25/A · Bimini, BahamasInadequate visual lookout by the pilots of both aircraft, resulted in their failure to see-and-avoid the other aircraft.Dec 22, 1990 · USCG · 2 aircraft · Minor damageNTSB LAX91LA062Accident · Serious injuriesLimited investigationFinal reportCessna 182E · Imperial, CAFuel exhaustion.Dec 22, 1990 · N3320Y · DestroyedNTSB LAX91LA053Accident · 2 fatalLimited investigationFinal reportCessna T210N · Douglas, AZAn inflight loss of control of the airplane due to the pilot's physical impairment from the consumption of alcohol. A factor which contributed to the accident was an inoperative vacuum system.Dec 22, 1990 · XBBCR · DestroyedNTSB MIA91GA050Accident · Minor injuriesFinal reportBell 206 B3 · St. Marks, FLThe pilot in command's failure to maintain safe altitude while descending over a coastline, at night, in visual meteorological conditions. Contributing to the accident was the pilot in command's failure to obtain a full weather briefing prior to departure…Dec 21, 1990 · N37AN · DestroyedNTSB ANC91FA018Accident · 1 fatalField investigationFinal reportCessna 208 · False Pass, AKThe pilot's improper decision to continue flight into an area of mountainous terrain and adverse weather conditions. The terrain and weather were factors.Dec 21, 1990 · N9444F · DestroyedNTSB SEA91LA036Accident · No injuriesLimited investigationFinal reportBeech D35 · Cedar City, UTA loss of engine power due to induction system icing. Factors related to the accident were: the adverse weather condition, and a blocked induction air filter.Dec 20, 1990 · N2911B · DestroyedNTSB MIA91LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · Deland, FLFailure of the instructor pilot to utilize carburetor heat in icing conditions.Dec 20, 1990 · N25945 · Substantial damageNTSB DEN91IA028Incident · No injuriesIncident investigationFinal reportBoeing 727-22 · Denver, COFailure of an engine bearing.Dec 20, 1990 · N40486 · Minor damageNTSB SEA91FA120Accident · 1 fatalField investigationFinal reportCessna 182H · Thompson, UTThe pilot's misjudged descent. Contributing to the accident was the dark night conditions.Dec 19, 1990 · N2466X · DestroyedNTSB MIA91LA047Accident · No injuriesLimited investigationFinal reportCASA C-212-200 · San Juan, PRLoss of control while flaring to land due to undetermined reasons.Dec 19, 1990 · N433CA · Substantial damageNTSB MIA91IA048Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · Sanford, FLCollapse of the nose landing gear during the landing roll due to inadequate nose gear assembly and failure of the nose landing gear drag link bolt.Dec 19, 1990 · N3062H · Minor damageNTSB CHI91LA047Accident · 2 fatalLimited investigationFinal reportCessna 175 · Boscobel, WIThe pilot's continued VFR flight into instrument meteorological conditions (IMC) and his failure to remain clear of the trees. Factors related to the accident were: the adverse weather conditions and the pilot's lack of instrument experience.Dec 19, 1990 · N6626E · DestroyedNTSB LAX91LA058Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas 369D · Keanae, HIFuel starvation caused by a loose fuel line 'b' nut, due to improper maintenance; and the failure of the pilot to correctly judge the landing flare during the autorotation.Dec 18, 1990 · N58240 · Substantial damageNTSB ANC91FA017Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Evanston, WYThe pilot's premature descent. Contributing to the accident was the pilot's fatigue and poor weather.Dec 18, 1990 · N4082H · DestroyedNTSB SEA91LA035Accident · No injuriesLimited investigationFinal reportCessna 182-E · Anacortes, WAThe poor inflight decision by the PIC to land on a short grass airstrip in strong gusty tailwind conditions.Dec 17, 1990 · N3017Y · Substantial damageNTSB NYC91LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln Park, NJImproper recovery from a bounced landings.Dec 17, 1990 · N89627 · Substantial damageNTSB MIA91WA046Incident · No injuriesForeign investigationCessna 402B · Nevis, WNDec 17, 1990 · N676MF · Minor damageNTSB LAX91LA057Accident · No injuriesLimited investigationFinal reportCessna 172L · Mcdermitt, NVIntentional buzzing conducted by the pilot. His poor judgement was a factor in the accident.Dec 17, 1990 · N4319Q · Substantial damageNTSB LAX91LA056Accident · No injuriesLimited investigationFinal reportCessna 152 · Livermore, CAThe student pilots failure to maintain directional control during the landing. A factor in the accident was his lack of total experience.Dec 17, 1990 · N4722P · Substantial damageNTSB NYC91LA050Accident · No injuriesLimited investigationFinal reportCessna 210 · Warwick, NYA power failure for undetermined reasons, resulting in a forced landing in unsuitable terrain.Dec 16, 1990 · N9480T · Substantial damage