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 CHI91DEP12Accident · No injuriesFinal reportSchweizer G-164-A · Elkhorn, WIThe pilot in command's failure to maintain adequate altitude.Aug 20, 1991 · N48635 · Substantial damageNTSB ANC91LA130Accident · Minor injuriesLimited investigationFinal reportCessna U206-G · Rainy Pass, AKThe pilot exceeded the climb performance of the aircraft.Aug 20, 1991 · N756WR · Substantial damageNTSB 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.Aug 19, 1991 · N35831 · Substantial damageNTSB 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.Aug 19, 1991 · N7501K · Substantial damageNTSB 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.Aug 19, 1991 · N52KP · Substantial damageNTSB 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.Aug 19, 1991 · N7966B · Substantial damageNTSB 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.Aug 19, 1991 · N26CZ · Substantial damageNTSB 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.Aug 18, 1991 · N2526C · DestroyedNTSB 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.Aug 18, 1991 · N5921R · Substantial damageNTSB 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.Aug 18, 1991 · N65372 · Substantial damageNTSB 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.Aug 17, 1991 · N350TH · Substantial damageNTSB 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.Aug 17, 1991 · N30258 · Substantial damageNTSB 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.Aug 17, 1991 · N2069H · Substantial damageNTSB 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.Aug 17, 1991 · N35PR · DestroyedNTSB 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.Aug 17, 1991 · N4368W · Substantial damageNTSB 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.Aug 17, 1991 · N3155 · No damageNTSB 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.Aug 17, 1991 · N6261Z · DestroyedNTSB DEN91LA115Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Parker, COPhysical impairment of the pilot in command for unknown reasons.Aug 17, 1991 · N2253K · Substantial damageNTSB 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.Aug 17, 1991 · N76AM · Substantial damageNTSB 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.Aug 17, 1991 · N8351K · Substantial damageNTSB ANC91FA128Accident · 3 fatalField investigationFinal reportMaule M-5 · Ruby, AKA loss of control inflight due to improper aircraft handling and alcohol impairment.Aug 17, 1991 · N9026E · DestroyedNTSB 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.Aug 16, 1991 · CGFTE · Substantial damageNTSB 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.Aug 16, 1991 · N1645G · DestroyedNTSB 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.Aug 16, 1991 · N16AC · Substantial damageNTSB 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.Aug 16, 1991 · N19171 · Substantial damageNTSB 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.Aug 16, 1991 · N64834 · Substantial damageNTSB 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.Aug 16, 1991 · N104SB · DestroyedNTSB LAX91LA360Accident · No injuriesLimited investigationFinal reportCessna 182 · Long Beach, CAThe failure of the pilot to perform a proper preflight inspection of the aircraft.Aug 16, 1991 · N5825B · Substantial damageNTSB 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.Aug 16, 1991 · N8577H · Substantial damageNTSB 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.Aug 16, 1991 · N80RS · Substantial damageNTSB 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.Aug 16, 1991 · N4535K · DestroyedNTSB 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.Aug 16, 1991 · N2842V · Substantial damageNTSB ATL91LA163Accident · No injuriesLimited investigationFinal reportBell 47D1 · Winton, NCThe pilot's selection of unsuitable terrain for landing the helicopter.Aug 16, 1991 · N1MH · Substantial damageNTSB 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.Aug 16, 1991 · N9HE · DestroyedNTSB 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.Aug 16, 1991 · N4164W · Substantial damageNTSB 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…Aug 16, 1991 · N5855M · DestroyedNTSB 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.Aug 15, 1991 · N4075W · DestroyedNTSB MIA91WA198Accident · No injuriesForeign investigationBeech E18S · Bimini, BahamasAug 15, 1991 · N4303Y · Substantial damageNTSB 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.Aug 15, 1991 · N8241 · Substantial damageNTSB 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.Aug 15, 1991 · N25496 · 2 aircraft · Substantial damageNTSB 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…Aug 15, 1991 · N735XG · DestroyedNTSB ATL91LA159Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Newton, GAThe failure of the pilot-in-command to maintain an adequate visual lookout for obstacles.Aug 15, 1991 · N84692 · Substantial damageNTSB LAX91LA358Accident · No injuriesLimited investigationFinal reportBeech J35 · San Jose, CAThe failure of the crankshaft counterweight retaining clip due to improper maintenance installation of the part.Aug 14, 1991 · N3028C · Substantial damageNTSB 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).Aug 14, 1991 · N38189 · Substantial damageNTSB 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.Aug 14, 1991 · N4820Q · Substantial damageNTSB 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…Aug 14, 1991 · N6262P · Substantial damageNTSB ANC91T#A02Accident · No injuriesClass 3Final reportPiper PA-18-150 · Kavik, AKAug 14, 1991 · N83593 · Substantial damageNTSB 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.Aug 14, 1991 · N5371G · Substantial damageNTSB 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.Aug 14, 1991 · N1017A · Substantial damageNTSB NYC91DNA03Accident · Serious injuriesFinal reportBeckloff Baby ACE D · Nantucket, MANo narrative included.Aug 13, 1991 · N7376 · Destroyed