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 CHI94LA313Accident · Serious injuriesLimited investigationFinal reportWilliam P. Bouda Varieze · Millard, NEthe loss of engine power due to fuel starvation from vapor lock. A factor associated with the accident is the soft terrain the pilot was forced to land upon.NTSB CHI94LA311Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · Cassoday, KSthe attempted low level flight/maneuver with inadequate visual lookout by the pilot-in-command.NTSB ANC94FA130Accident · 1 fatalField investigationFinal reportPiper PA-18 · Gulkana, AKThe pilot's failure to maintain clearance from terrain.NTSB NYC94LA169Accident · No injuriesLimited investigationFinal reportDonald E. Kovol Quickie 2 · Akron, OHThe failure of the pilot to maintain airspeed which resulted in an inadequate flare and a hard landing. A factor was the pilot's lack of experience in the airplane.NTSB NYC94LA168Accident · No injuriesLimited investigationFinal reportBeech C35 · Rhinebeck, NYThe pilot's inadequate preflight planning and inaccurate fuel consumption calculations, resulting in fuel starvation and engine failure, and the subsequent collision with trees during a forced landing. A factor related to the accident was the turbulent air…NTSB LAX94LA352Accident · Minor injuriesLimited investigationFinal reportHughes 369E · Volcano, HIthe pilot's failure to maintain adequate main rotor rpm and the resultant inadvertent skid contact with the ground.NTSB LAX94LA351Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Twentynine Palm, CAthe cause of the loss of engine power could not be determined. The dirt berm was a factor in this accident.NTSB LAX94LA350Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Rescue, CAThe pilot's delayed go-around. His inadequate compensation for the wind was a factor.NTSB FTW94FA287Accident · Serious injuriesField investigationFinal reportAerostar RX-7 · Fountain, COThe pilot's improper aircraft handling during landing in high wind conditions. A factor was the high wind.NTSB CHI94LA312Accident · No injuriesLimited investigationFinal reportCessna 172 · Milwaukee, WIthe pilot's improper flare during touchdown. A factor in the accident was the rupture of the nose landing gear tire.NTSB SEA94T#A05Accident · No injuriesClass 3Final reportBell 206L3 · Libby, MTNTSB SEA94LA232Accident · No injuriesLimited investigationFinal reportCessna 210D · Paris, IDAn inadvertent wheels up landing.NTSB SEA94LA230Accident · No injuriesLimited investigationFinal reportCessna 182B · Lummi Island, WAInadequate compensation for wind conditions. A factor to the accident was: tailwind.NTSB NYC94FA166Accident · 2 fatalField investigationFinal reportCessna 310R · Blain, PAThe pilot's impairment of judgment and performance due to drugs, failure to maintain control of the airplane, and exceeding the design stress limits of the airplane, which resulted in an in-flight breakup of the airplane. A factor related to the accident was:…NTSB MIA94LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Englewood, FLThe failure of the number four connecting rod and rod bolts due to oil starvation (extreme heat) for undetermined reasons, resulting in a total loss of engine power, forced landing, and subsequent in-flight collision with trees and terrain.NTSB MIA94LA205Accident · No injuriesLimited investigationFinal reportCessna 172N · Orlando, FLThe pilot-in-command's improper landing flare/touchdown, resulting in a hard landing, and subsequent separation of the nose gear.NTSB LAX94LA369Accident · No injuriesLimited investigationFinal reportCessna T210L · Kettleman City, CAThe pilot's selection of the wrong runway for takeoff and his failure to maintain runway alignment. The sun glare was a factor in this accident.NTSB LAX94LA349Accident · 1 fatalLimited investigationFinal reportCessna 172M · Jackpot, NVthe pilot's failure to maintain aircraft control due to spatial disorientation during a moonless night departure over an area without ground reference lights. A factor in the accident was the pilot's lack of instrument training and experience.NTSB LAX94LA348Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Orland, CAThe pilot's failure to follow checklist procedures to assure that the fuel selector was in the both fuel tanks position. Fuel starvation and the dark night were factors in this accident.NTSB CHI94FA310Accident · 1 fatalField investigationFinal reportCessna 182H · Plymouth, MICarburetor ice, and improper use of (or failure to use) the carburetor heat. Factors related to the accident were: carburetor icing (weather) conditions, and the lack of suitable terrain for a forced landing.NTSB ANC94LA128Accident · No injuriesLimited investigationFinal reportMaule M5 · Port Alsworth, AKThe pilot's selection of unsuitable terrain.NTSB NYC94FA165Accident · 1 fatalField investigationFinal reportBellanca 8-KCAB · Chatsworth, NJThe pilot's inadequate preflight that failed to detect water- contaminated fuel which resulted in the loss of engine power and the pilot's decision to conduct flight at an altitude too low to initiate emergency procedures.NTSB LAX94LA347Accident · No injuriesLimited investigationFinal reportCessna 182P · Mesa, AZthe pilot's failure to properly secure the aircraft prior to a start attempt by handpropping.NTSB FTW94LA291Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Hurst, TXThe certificated flight instructor's inadequate supervision. A factor was the pilot's failure to maintain proper landing alignment.NTSB FTW94LA289Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Ardmore, OKThe partial loss of power due to a cylinder head separation. Factors were the lack of suitable terrain for the forced landing and the low ceiling.NTSB FTW94LA286Accident · No injuriesLimited investigationFinal reportCessna 150M · Mesquite, TXThe unfavorable gusting winds. A factor was the pilot's failure to maintain directional control.NTSB CHI94LA309Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7-15 · Storm Lake, IAthe pilot's excessive rate of descent to landing. Factors in the accident were the gusts and downdraft.NTSB CHI94LA308Accident · No injuriesLimited investigationFinal reportThalman Thorp T-18 · Kenosha, WIthe pilot's failure to use carburetor heat in carburetor icing conditions. A factor associated with the accident is the prevailing carburetor icing conditions.NTSB CHI94FA307Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Lincoln, ILThe pilot's failure to maintain airspeed while performing a go-around.NTSB ANC94LA131Accident · No injuriesLimited investigationFinal reportCessna 180B · Fort Yukon, AKThe pilot's improper use of the flaps and flight controls, and a delay in aborting the takeoff. A factor in the accident was glassy water conditions.NTSB ANC94LA129Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tok, AKThe worn cam shaft lobe and worn valve lifter.NTSB SEA94LA228Accident · Minor injuriesLimited investigationFinal reportSikorsky S-64F · Libby, MTThe flight crew allowed the helicopter's weight and balance to be exceeded, and the external load (tank) jettison system failed to operate. A factor related to the accident was: the false indication on the retardant quantity indicator.NTSB NYC94LA164Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Block Island, RIThe pilot maintaining excessive airspeed during the landing, resulting in a touchdown on the runway with insufficient distance to stop, and a subsequent intentional ground loop and collision with the terrain. Also causal was the pilot's failure to abort the…NTSB NYC94LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Vine Grove, KYThe pilot's (1) inadequate compensation for wind conditions and (2) failure to align with the runway during landing touch down.NTSB NYC94LA162Accident · No injuriesLimited investigationFinal reportCessna 310Q · Salem, OHThe pilot misjudged altitude and distance which resulted in a undershoot of the runway and collision with objects.NTSB MIA94LA204Accident · No injuriesLimited investigationFinal reportCessna 188B · Indian River, FLThe total loss of engine power for undetermined reasons over terrain unsuitable for a forced landing.NTSB LAX94LA345Accident · Minor injuriesLimited investigationFinal reportCessna 310L · Agua Dulce, CAthe pilot's failure to maintain control of the aircraft while reaching cross cockpit for the flap control.NTSB ANC94LA126Accident · No injuriesLimited investigationFinal reportCessna 208 · Cape Sabine, AKThe pilot's improper preflight planning, inadequate compensation for the wind conditions, not following procedures and directives, and overconfidence in his abilities, and the operators inadequate surveillance of the operation.NTSB SEA94LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Everett, WAThe pilot failed to maintain directional control.NTSB LAX94LA344Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Five Points, CAthe pilot's inadequate compensation for the existing crosswind condition and his failure to maintain the proper runway alignment.NTSB LAX94LA343Accident · No injuriesLimited investigationFinal reportCessna 195 · Palo Alto, CAthe pilot's improper use of the airplane's brakes during the landing rollout.NTSB LAX94LA342Accident · No injuriesLimited investigationFinal reportTexas Helicopter M74 · Salinas, CAfuel exhaustion due to the pilot's inadequate preflight planning and in-flight fuel consumption monitoring.NTSB BFO94LA159Accident · No injuriesLimited investigationFinal reportBell UH-1B · Carrabasset, MEFracture failure of the tail rotor drive intermediate gearbox.NTSB ATL94LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Headland, ALThe failure of the student pilot to maintain control of the aircraft during a crosswind landing.NTSB ANC94LA125Accident · No injuriesLimited investigationFinal reportCessna 170B · Fort Yukon, AKThe fatigue failure of the right main landing gear spring.NTSB ANC94LA117Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Anchorage, AKThe binding in the mechanical fuel selector valve, and lack of suitable terrain for a forced landing.NTSB ANC94LA110Accident · No injuriesLimited investigationFinal reportBell B-206 · Gustavus, AKThe pilot misjudged his distance/altitude from the landing area, and his lack of recent night flying experience. Factors which contributed to the accident were: the pilot's failure to assure that he would be landing with sufficient light, and the dusk/dark…NTSB SEA94LA226Accident · No injuriesLimited investigationFinal reportCessna 182P · Yamhill, ORThe pilot's failure to maintain directional control. A factor to the accident was: an inadequate recovery from a bounced landing.NTSB MIA94LA203Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Egypt, MSPilot-in-command's inadvertent stall during an agricultural turn resulting in the loss of control and subsequent in flight collision with terrain.NTSB MIA94LA202Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12-D · Punta Gorda, FLThe failure of the pilot-in-command to tiedown the airplane prior to attempting an engine start by hand propping. Contributing to the accident was the pilot's complacency.