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 CHI91DEP12Accident · No injuriesFinal reportSchweizer G-164-A · Elkhorn, WIThe pilot in command's failure to maintain adequate altitude.NTSB ANC91LA130Accident · Minor injuriesLimited investigationFinal reportCessna U206-G · Rainy Pass, AKThe pilot exceeded the climb performance of the aircraft.NTSB SEA91LA212Accident · No injuriesLimited investigationFinal reportCessna U206F · Nimrod, ORThe fractured crankshaft resulting in engine seizure followed by a forced landing on rough and uneven terrain resulting in separation of the nose gear.NTSB LAX91LA362Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Verona, CAThe pilot's improper planning/decision to depart from a runway with high vegetation along the edge and subsequent collision with terrain.NTSB CHI91DEM08Accident · Serious injuriesFinal reportFisher FT101 · Sparta, MIAn improper preflight inspection by the pilot. Factors contributing to this accident were inadequate altitude for the turn back towards the runway and the stall/spin encountered by the pilot.NTSB ANC91LA129Accident · No injuriesLimited investigationFinal reportCessna 172 · Montague Island, AKThe pilot's failure to maintain control of the airplane during the landing roll. A factor was the unsuitable terrain selected for landing by the pilot, which was loose gravel, rough and uneven.NTSB ANC91LA127Accident · No injuriesLimited investigationFinal reportCessna 180A · King Salmon, AKThe pilot's failure to maintain directional control of the airplane during the takeoff run. Contributing to the accident was the rough water.NTSB LAX91LA365Accident · 2 fatalLimited investigationFinal reportPiper PA-38-112 · Oceano, CAUnknown. The main airplane wreckage and the body of the pilot are presumed lost at sea.NTSB LAX91LA361Accident · No injuriesLimited investigationFinal reportCessna 172G · Hilo, HIFuel exhaustion due to the installation of a non standard propeller for which no performance charts were available.NTSB FTW91LA150Accident · No injuriesLimited investigationFinal reportHughes 269A-1 · No. Little Rock, ARThe pilot's failure to maintain main rotor RPM, his delayed flare, and the improper touchdown.NTSB SEA91LA214Accident · No injuriesLimited investigationFinal reportBeech 58TC · Kalispell, MTThe pilot's failure to extend the landing gear. A factor contributing to the accident was the pilot's failure to identtify a down and locked landing gear condition prior to touchdown.NTSB SEA91LA213Accident · No injuriesLimited investigationFinal reportCessna 177 · Nampa, IDThe pilot's delay in initiating a go-around (aborted landing) and his improper raising of the flaps. Factors related to the accident were: the high density altitude, tailwind, and the pilot's selection of the wrong runway.NTSB SEA91LA211Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Anaconda, MTAn inadvertent stall during initial climb. The high density altitude and a premature liftoff by the pilot were factors.NTSB SEA91LA210Accident · 1 fatalLimited investigationFinal reportWeyerts Rans S-10 · Stanwood, WAAn undetermined loss of engine power and the pilot's allowing the airspeed to decelerate below the stall speed during the subsequent forced landing.NTSB NYC91LA214Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Montauk, NYThe pilot made a hard landing, resulting in the main landing gear collapsing. Contributing to the accident was the pilot's interpretation of the wind conditions, misjudgment of the flare causing the airplane to balloon and stall.NTSB MIA91IA199Incident · Minor injuriesIncident investigationFinal reportBritish Aerospace BA-3100 · Fort Myers, FLThe physiological incapacitation of the captain and his loss of consciousness due to a syncopal pleural event.NTSB DEN91LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-150 · Seagraves, TXThe pilot's improper inflight planning which resulted in loss of aircraft control due to wake turbulence.NTSB DEN91LA115Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Parker, COPhysical impairment of the pilot in command for unknown reasons.NTSB DEN91FA116Accident · 1 fatalField investigationFinal reportCessna 182N · Climax, COImproper in-flight planning/decision by the non-rated pilot and his failure to maintain adequate airspeed, which resulted in a stall. A factor related to the accident was: the pilot's lack of qualification.NTSB CHI91DTG08Accident · No injuriesFinal reportGrumman G164B · Minto, NDInadequate aircraft servicing, inadequate aircraft preflight, fuel contamination, and unsuitable soft terrain in which to effect an emergency landing.NTSB ANC91FA128Accident · 3 fatalField investigationFinal reportMaule M-5 · Ruby, AKA loss of control inflight due to improper aircraft handling and alcohol impairment.NTSB SEA91LA209Accident · No injuriesLimited investigationFinal reportCessna 172M · Oak Harbor, WAThe pilot's allowing the airspeed to decay below the stall speed. Factors contributing to the accident were the pilot's failure to maintain directional control and the pilot's lack of total recent experience.NTSB SEA91LA208Accident · Minor injuriesLimited investigationFinal reportChampion 7GCAA · Townsend, MTThe instructor pilot's not maintaining the power off stall speed resulting in a stall condition. A factor contributing to the accident was the lack of sufficient altitude to enable a successful recovery from the stall.NTSB NYC91LA213Accident · No injuriesLimited investigationFinal reportCessna 150C · Kemblesville, PAThe instructor pilots' inadequate supervision, the student pilots' overshoot of the simulated landing area, and the power loss for undetermined reasons.NTSB NYC91LA211Accident · No injuriesLimited investigationFinal reportCessna 150 · Sharon, OHThe improper use of carburetor heat by the pilot, which resulted in a loss of engine power and subsequent forced landing on rough terrain. A factor related to the accident was the lack of total flight experience of the student pilot.NTSB NYC91LA210Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Sandusky, OHThe pilot initiated an emergency landing when the engine RPM went to zero due to a broken tachometer cable. He did not attain the proper touchdown point and overran the end of the runway.NTSB NYC91FA212Accident · 1 fatalField investigationFinal reportBeech 58 · Brookhaven, NYPilot physiological incapacitation which resulted in a loss of control in flight, and an uncontrolled descent into water.NTSB LAX91LA360Accident · No injuriesLimited investigationFinal reportCessna 182 · Long Beach, CAThe failure of the pilot to perform a proper preflight inspection of the aircraft.NTSB FTW91DPG19Accident · No injuriesFinal reportGrumman G-164A · Allport, ARA loss of power for undetermined reason. A factor was the terrain on which the pilot made the forced landing.NTSB DEN91LA136Accident · No injuriesLimited investigationFinal reportCessna 421B · Pagosa Springs, COInadequate preflight of the aircraft by the pilot in command. A factor was: failure of the pilot in command to properly latch the cargo door.NTSB DEN91LA114Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Clovis, NMFailure of the pilot to maintain clearance from rising/uneven terrain. Factors related to the accident were: the light conditions at dusk, and the lack of visual cues for the pilot.NTSB CHI91LA267Accident · No injuriesLimited investigationFinal reportCessna 150M · Old Monroe, MOThe separation of the throttle control cable. Contributing to the accident was the rough terrain on which a forced landing was made.NTSB ATL91LA163Accident · No injuriesLimited investigationFinal reportBell 47D1 · Winton, NCThe pilot's selection of unsuitable terrain for landing the helicopter.NTSB ATL91LA162Accident · 1 fatalLimited investigationFinal reportHarold J. Eagen Pitts Special S-1C · Monroe, GAContamination and water existing in the fuel system which resulted in engine stoppage and the pilot's continued flight with a known aircraft deficiency.NTSB ATL91LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300D · Chamblee, GAThe pilot's premature lift off when he failed to identify rotation airspeed and the subsequent inadvertent stall of the airplane.NTSB ATL91FA161Accident · 3 fatalField investigationFinal reportCessna 402B · Kathleen, GAThe pilot's failure to maintain aircraft control while descending at night. Factors related to the accident were: darkness, fog, the pilot's lack of qualification in multi-engine aircraft, his lack of experience in this type of aircraft, his overconfidence in…NTSB SEA91FA207Accident · 6 fatalField investigationFinal reportPiper PA-32 · Gustavus, AKVFR flight by the pilot into instrument meteorological conditions (IMC), and the pilot's failure to maintain sufficient altitude and/or clearance from mountainous terrain. Factors related to the accident were: the adverse weather and terrain conditions.NTSB MIA91WA198Accident · No injuriesForeign investigationBeech E18S · Bimini, BahamasNTSB LAX91LA359Accident · 1 fatalLimited investigationFinal reportBenson/Ambrocini/Wentzel B-8MJ · Turlock, CAThe pilot's over rotation of the gyrocopter during the takeoff sequence which resulted in a loss of control. Contributing to the accident was the poor maintenance practices performed on the machine.NTSB CHI91LA263Accident · No injuriesLimited investigationFinal reportBeech 36 · Davenport, IAThe inadequate visual lookout and poor inflight planning and decision making by the pilot of N97867. Factors in the accident are inoperative exterior lights and radio communication not possible.NTSB CHI91FA264Accident · 2 fatalField investigationFinal reportCessna 182Q · Jerseyville, ILFailure of the pilot to follow proper procedures during a go-around maneuver, and his failure to maintain adequate airspeed, which resulted in an inadvertent stall. Factors related to the accident were: the pilot's improper use of the flaps, his improper use…NTSB ATL91LA159Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Newton, GAThe failure of the pilot-in-command to maintain an adequate visual lookout for obstacles.NTSB LAX91LA358Accident · No injuriesLimited investigationFinal reportBeech J35 · San Jose, CAThe failure of the crankshaft counterweight retaining clip due to improper maintenance installation of the part.NTSB CHI91LA265Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Mosinee, WIThe pilot's poor preflight planning/preparation, and the selection of unsuitable terrain for takeoff. A related factor was the grassy runway (farm field).NTSB CHI91DCJ06Accident · 1 fatalFinal reportCessna A188D · Gothenburg, NEThe pilot's failure to maintain airspeed which resulted in a stall. A factor related to the accident was the pilot's abrupt handling of the airplane.NTSB ATL91LA158Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Waxhaw, NCThe spatial disorientation experienced by the pilot in IMC, his failure to maintain aircraft control, and the exceeding of the design stress limits of the aircraft. Factor(s) in this accident were: the pilot's inadequate preflight planning, the VFR flight…NTSB ANC91T#A02Accident · No injuriesClass 3Final reportPiper PA-18-150 · Kavik, AKNTSB ANC91LA125Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Ugashik, AKWas the pilot-in-command's failure to maintain directional control of the airplane during the takeoff run. Contributing to the accident was the rough water.NTSB ANC91LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Eagle River, AKThe pilot's failure to maintain airspeed during climbout and lack of aircraft control. Contributing to the accident was both the downdraft and gusting wind.NTSB NYC91DNA03Accident · Serious injuriesFinal reportBeckloff Baby ACE D · Nantucket, MANo narrative included.