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 FTW93IA067Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC8-55 · Dfw Airport, TXFailure of an engine turbine wheel for undetermined reasons.NTSB FTW93FA068Accident · 2 fatalField investigationFinal reportCessna 150J · Porter, TXInadvertent stall. Factors were the pilot's failure to follow the published checklist and the improper flap settingNTSB BFO93FA050Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Ligonier, PAVisual flight rules (VFR) flight by the pilot into instrument meteorological conditions (IMC), and the pilot's failure to maintain sufficient altitude from the wooded terrain. The terrain and adverse weather conditions were related factors.NTSB SEA93LA051Accident · No injuriesLimited investigationFinal reportBeech 58P · Hanksville, UTAn improper fuel selector valve position, fuel starvation, and inadequate remedial action. Factors include soft, rough terrain.NTSB CHI93LA071Accident · No injuriesLimited investigationFinal reportDon Showalter Lancair 320 · Madison, WIA jammed main landing gear brake.NTSB BFO93LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Manorhaven, NYThe partial power loss due to induction system icing and the pilots failure to apply carburetor heat during weather conducive to induction system icing.NTSB ATL93LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Salisbury, NCThe pilot became lost and exhausted the airplane fuel supply.NTSB ATL93LA050Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Goldsboro, NCThe pilot's improper decision in attempting a night landing at an airport without operating runway lights which resulted in a touchdown off the runway. Factors which contributed to the accident were: an airplane lighting malfunction for an undetermined…NTSB LAX93FA093Accident · 2 fatalField investigationFinal reportBell 206B · Hayward, CAThe pilot's continued flight into known adverse weather conditions and continued VFR flight into instrument meteorological conditions. Contributing to the accident were dark night light conditions and rain.NTSB FTW93LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe pilot's inadequate flare and the improper recovery from a bounced landingNTSB FTW93LA065Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Santa Fe, NMThe pilot's failure to maintain directional control. A factor was the snow conditionsNTSB CHI93LA070Accident · Serious injuriesLimited investigationFinal reportAero Commander 500-B · Susank, KSThe pilot's continued flight into adverse weather and the owner's representation that the airplane met the requirements for flight into icing conditions. The weather and airframe ice were factors in the accident.NTSB SEA93IA050Incident · No injuriesIncident investigationFinal reportBeech 1900C · Riverton, WYThe pilot's disorientation. Factors include snow, fog, snow covered terrain, and a drainage ditch.NTSB LAX93LA094Accident · No injuriesLimited investigationFinal reportCessna 150 · Torrance, CA1) The pilot misjudging the airplane's landing flare, and 2) the pilot's improper recovery from a bounced landing. A factor in this accident was the pilot's lack of total aircraft experience.NTSB BFO93FA019Accident · 2 fatalField investigationFinal reportHughes 269C · Tonawanda, NYImproper inflight planning/decision by the pilot and his failure to maintain clearance from an obstacle during flight. Factors related to the accident include poor visibility and weather conditions at dusk, and the pilot's excessive airspeed for the…NTSB FTW93IA064Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC9-82 · Dfw Airport, TXThe inaccurate safety advisory provided by the tower operator. A factor was the emergency evacuationNTSB BFO93LA020Accident · No injuriesLimited investigationFinal reportDornier DO-228-202 · Manchester, NHIncorrect installation of the seals in the nose gear assembly, which prevented the nose gear from locking in the down position.NTSB BFO93FA018Accident · 1 fatalField investigationFinal reportCessna 182P · Stow, MAAn inadequate preflight by the pilot, which allowed water contamination in the fuel and subsequent loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in a stall.NTSB MIA93LA047Accident · 1 fatalLimited investigationFinal reportCessna 337H · New Smyrna Bch, FLThe pilot-in-command's failure to maintain altitude while maneuvering in a turn at a low altitude, resulting in an in-flight collision with the ocean.NTSB DEN93LA022Accident · No injuriesLimited investigationFinal reportCessna T210L · Monte Vista, COA loss of control during landing when the aircraft struck a snowbank which was left on the runway as a result of inadequate plowing.NTSB DEN93IA025Incident · No injuriesIncident investigationFinal reportBoeing 767-222 · Denver, COMedical incapacitation of the first officer.NTSB CHI93LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · La Pointe, WISpatial disorientation of the pilot.NTSB CHI93IA069Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-311 · Savoy, ILThe total failure of the inboard right main landing gear wheel axle during the initial climb.NTSB LAX93LA091Accident · Serious injuriesLimited investigationFinal reportCessna 172 · San Jacinto, CAThe flight's encounter with unforecast clear air turbulence.NTSB CHI93IA068Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Detroit, MIThe manufacturer's inadequate design of the fuel transfer tube system, which loosened/disconnected during engine operation.NTSB SEA93GA049Accident · No injuriesFinal reportPiper PA-18-135 · Council, IDThe pilot's failure to maintain proper altitude during the low pass. The snow covered terrain and the pilot's inadequate preflight preparation were factors.NTSB CHI93LA066Accident · Minor injuriesLimited investigationFinal reportCessna 310R-II · Marysville, KSThe pilot's failure to maintain sufficient airspeed. Factors contributing to the accident were the icing conditions encountered, and the windshield & airframe ice.NTSB ANC93IA026Incident · No injuriesIncident investigationFinal reportGrumman G-21A · Akutan, AKThe incident was caused by the pilots improper compensation for the winds. Factors were the microburst, the rough water, and the pilot's inadequate evaluation of the weather conditions.NTSB MIA93LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-23 · Tampa, FLPoor in-flight planning/decision by the CFI resulting in the total loss of engine power from both engines due to fuel exhaustion.NTSB MIA93LA046Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Holly Springs, MSThe pilot-in-command's failure to maintain airspeed while maneuvering during a forced landing, resulting in an in-flight loss of control (stall), and subsequent collision with terrain. Contributing to the accident was a total loss of engine power in flight…NTSB CHI93LA065Accident · No injuriesLimited investigationFinal reportCessna 172N · Warren, MNThe student pilot's failure to maintain directional control.NTSB ANC93LA025Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35 · Nome, AKFuel starvation due to improper refueling procedures by the FBO personnel, inadequate preflight by the pilot, and resultant ice in the fuel, which blocked fuel flow to the engines. A factor was the lack of suitable terrain for a forced landing.NTSB MIA93LA045Accident · Serious injuriesLimited investigationFinal reportBoeing 767-323ER · Sarasota, FLThe in-flight encounter with weather and the failure of the passengers to comply with the instructions of the flightcrew.NTSB FTW93LA062Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wichita Falls, TXThe pilot's failure to maintain directional control.NTSB CHI93LA064Accident · No injuriesLimited investigationFinal reportCessna T210K · Metropolis, ILThe fatigue failure of the exhaust valve.NTSB ANC93LA024Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Scammon Bay, AKThe pilots failure to follow VFR procedures. A factor was the whiteout snow condition.NTSB CHI93FA063Accident · 3 fatalField investigationFinal reportCessna T337G · Smiths Creek, MIThe pilot-in-command's failure to maintain control of the airplane during the approach. Factors which contributed to the accident were the adverse weather conditions and the dark night.NTSB SEA93FA048Accident · 4 fatalField investigationFinal reportBell 206B3 · Ogden, UTThe pilot's continuation of VFR flight into instrument meteorological conditions, and his decision to continue his landing attempts under the adverse weather conditions. Factors contributing to the accident were the low clouds, fog and mountainous terrain.NTSB MIA93LA044Accident · No injuriesLimited investigationFinal reportBeech 1900D · Fort Myers, FLFailure of the pilot-in-command to follow the checklist and complacency of the pilot-in-command for failure to extend the landing gear before landing.NTSB CHI93MA061Accident · No injuriesMajor investigationFinal reportSaab-Scania 340A · Hibbing, MNThe first officer's failure to maintain a proper descent rate during the landing, and the captain's inadequate supervision by not taking timely action to ensure a safe landing. Factors which contributed to the accident were: the company's failure to provide…NTSB CHI93LA062Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Milwaukee, WIFailure of the pilot to perform an aborted landing and failure to select a proper touchdown point on the runway.NTSB ATL93LA047Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Roanoke Rapids, NCThe pilot-at-control's failure to use carburetor heat resulting in a loss of engine power due to carburetor ice. A factor which contributed to the accident was weather conducive to carburetor ice.NTSB ATL93FA046Accident · 2 fatalField investigationFinal reportBeech A23 · Ft. Bragg, NCThe loss of engine power for undetermined reasons and the loss of control during the forced landing.NTSB MIA93WA043Accident · No injuriesForeign investigationPiper PA-31-350 · Bimini, BahamasNTSB MIA93IA052Incident · Minor injuriesIncident investigationFinal reportBalloon Works Firefly 7-15 · Orlando, FLPoor in-flight planning/decision by the pilot, and excessive descent resulting in a hard landing.NTSB LAX93LA089Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Gorman, CA1) The carburetor inlet fuel line being improperly installed by maintenance personnel which allowed the carburetor to become contaminated with metal particles, and 2) the carburetor float valve being jammed by metal particles which allowed excessive fuel to…NTSB LAX93LA088Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Concord, CAThe engine manufacturer failing to properly install tab washers during overhaul which resulted in one bolt becoming loose and being ingested through various engine gear drives. The ingestion and loose oil pump cover resulted in the engine running rough and a…NTSB LAX93LA087Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Folsom, CAThe pilot failing to maintain an adequate visual lookout resulting in the helicopter colliding with electrical transmission wires.NTSB BFO93LA017Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Philipsburg, PAThe inadequate removal of snow from the runways by airport personnel and the procedures/directives for airport snow removal not understood.NTSB ATL93LA049Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Crossville, TNThe pilot's failure to follow checklist procedures in that he did not utilize the alternate gear extension method when electrical power was lost. A factor was his failure to follow the checklist when he failed to turn on the generators prior to flight, which…