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 LAX91LA357Accident · No injuriesLimited investigationFinal reportRobinson R22B · Chandler, AZThe failure of the student pilot to maintain adequate control of the helicopter and stop a descent, while maneuvering. The pilot's disorientation was a contributing factor.NTSB LAX91IA297Incident · No injuriesIncident investigationFinal reportBoeing 747-200 · Los Angeles, CAThe inadequate runway safety area inherent in the airport design, and, the ATC clearance procedures in use which failed to take into consideration the substandard runway safety area. Factors in the incident were the dark night time conditions and the…NTSB LAX91FA355Accident · Minor injuriesField investigationFinal reportPiper PA-23-250 · Hawthorne, CAOverconfidence in the airplane's ability and his personal ability by the instructor pilot (CFI), by intentionally shutting off fuel to an engine during a critical part of flight. The aircraft's lack of single engine performance was a related factor.NTSB FTW91FA147Accident · 3 fatalField investigationFinal reportBeech 35-C33 · Dalhart, TXThe pilot's flight into known adverse weather. Factors were the pilot's lack of instrument experience and existing weather conditions.NTSB CHI91LA261Accident · No injuriesLimited investigationFinal reportPiper PA-32-R300 · Lake In Hills, ILThe pilot's failure to perform an adequate preflight by assuring the gear lever was in the down and locked position.NTSB CHI91LA230Accident · No injuriesLimited investigationFinal reportCessna 172 · Metropolis, ILMiscellaneous equipment not removed (foam rubber) and inadequate preflight by the pilot.NTSB CHI91FA266Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Boyne City, MIThe pilot in command's failure to maintain proper altitude. A factor contributing to the accident was the pilot in command's diverted attention..NTSB CHI91DCA02Accident · Minor injuriesFinal reportManville Avid Flyer · Mexico, MOFailure of the pilot to maintain directional control during a landing roll. A factor associated with the accident is the pilot's lack of familiarity with the accident airplane.NTSB ATL91LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Roxobel, NCThe failure of the left magneto stop pin, resulting in the seizure of the magneto and the failure of the magneto drive gear, and ultimately engine stoppage. A factor in this accident was: the presence of trees at the forced landing area.NTSB ANC91LA126Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Seldovia, AKThe pilot misjudged fuel consumption for the airplane during flight and experienced complete fuel exhaustion.NTSB SEA91LA206Accident · No injuriesLimited investigationFinal reportBeech V35B · Belgrade, MTThe pilot's failure to maintain a positive rate of climb during the takeoff. Factors contributing to the accident were the open cabin window and the pilot's diverting his attention.NTSB NYC91LA208Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Butler, PAThe pilot failed to maintain control of the airplane, resulting in the airplane departing the runway and impacted with the terrain.NTSB NYC91LA207Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bear Mountain, NYThe pilot's improper preflight and planning, which resulted in fuel exhaustion and a forced landing in water.NTSB LAX91LA364Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Wasco, CAA total loss of engine power due to a fracture of the camshaft and the subsequent forced landing into a soft field.NTSB FTW91LA145Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Paulina, LAThe pilot's failure to maintain adequate visual lookout for the wires and his misjudging clearance when he attempted to fly under the wires.NTSB CHI91MA260Accident · No injuriesMajor investigationFinal reportBritish Aerospace 3201 · St Louis, MOFailure of the pilot(s) to follow the correct emergency procedure. Factors related to this accident were: inadequate system design by the manufacturer, which allowed hydraulic line vibration, fatigue failure of the line, and loss of fluid from the normal…NTSB CHI91FA259Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Guide Rock, NESpatial disorientation, and exceeding the design limits of the aircraft. Factors related to the accident are inadequate preflight planning, VFR flight into IMC, flight weather avoidance assistance not followed, excessive altitude, physical impairment…NTSB ANC91LA122Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Iliamna, AKFuel contamination and the pilot's failure to perform an adequate preflight of the airplane. Contributing to the accident was the rough, uneven terrain of the tundra landing area.NTSB SEA91LA166Accident · No injuriesLimited investigationFinal reportWaco UBF · Lincoln City, ORImproper planning/decision by the pilot, and his delay in aborting the takeoff. The tailwind & proximity of trees/brush were related factors.NTSB NYC91LA206Accident · No injuriesLimited investigationFinal reportCessna 172L · Magnolia, OHThe pilot's improper starting procedure.NTSB LAX91LA354Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Monterey, CAThe failure of the pilot to maintain directional control of the aircraft during the landing roll.NTSB LAX91LA353Accident · No injuriesLimited investigationFinal reportCessna 172B · King City, CAThe total loss of engine power in cruise flight due to the failure of the number 3 cylinder exhaust valve, resulting in a forced landing, and subsequent nose over on landing roll out.NTSB LAX91LA352Accident · No injuriesLimited investigationFinal reportCessna 210 · Chino Valley, AZThe failure of the pilot to maintain directional control. A factor in the accident was the slippery condition of the road surface being used as a runway.NTSB CHI91LA257Accident · No injuriesLimited investigationFinal reportBell 47G · Lake Ozark, MOFailure of the rotorcraft's tail boom in flight. Factors related to the accident were reduced aircraft control available to the pilot.NTSB CHI91LA256Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · Valparaiso, INThe pilot in command's failure to maintain airspeed. A factor contributing was improper maintenance (design change) performed by an unqualified person (pilot in command).NTSB CHI91DER14Accident · Serious injuriesFinal reportMilner, Dick G Glasair II · Milaca, MNThe pilot's failure to maintain aircraft control during takeoff and departure which resulted in a dragged wing and ground impact. Related factors are the rough airstrip, the pilot's lack of expereince in the type of operation, and the premature lift-off.NTSB CHI91DCD02Accident · 1 fatalFinal reportCanadian Car & Foundry Harvard Mark IV · Ida Grove, IAThe pilot's failure to maintain airspeed.NTSB SEA91LA205Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Boring, ORFuel exhaustion and improper inflight decision by the pilot in command followed by rough terrain during the forced landing. Factors contributing to the accident were a fuel system leak and the pilot's failure to refuel en route.NTSB SEA91FA203Accident · 1 fatalField investigationFinal reportChristen Industries Pitts S-2B · Scappoose, ORThe pilot's misjudgment of altitude, while performing an aerobatic maneuver, and his failure to maintain ground clearance.NTSB MIA91LA197Accident · No injuriesLimited investigationFinal reportCessna A188B · Monticello, FLLoss of engine power due to undetermined reasons and the unsuitable terrain encountered during the forced landing.NTSB MIA91LA196Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Cleveland, MSThe pilot's decision to continue the flight with reduced visual lookout due to a dirty foggy windshield.NTSB FTW91LA146Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Patterson, LAThe pilot's failure to maintain clearance with the electical power line. Factors were the bright sun and chemical residue on the windshield.NTSB DEN91LA112Accident · No injuriesLimited investigationFinal reportLars Avid Flyer · Colorado Spring, COThe pilot's delay in flaring the airplane. Factors were: (1) stuck piston rings and (2) the pilot's failure to use flaps.NTSB DEN91FA111Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Colorado Spring, COThe pilot exceeded weight and balance limitations. Factors were: high density altitude and unsuitable terrain.NTSB CHI91LA262Accident · No injuriesLimited investigationFinal reportCessna 310 · Plattsmouth, NEImproper maintenance by the owner/pilot. A factor related to the accident was the built-up of corrosion on he landing gear retraction system.NTSB ANC91LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gulkana, AKThe pilot's failure to maintain adequate airspeed, resulting in a stall, hard landing and collapse of the main landing gear.NTSB ANC91LA119Accident · Serious injuriesLimited investigationFinal reportCessna 185F · Angoon, AKThe pilot's failure to maintain a proper descent rate. Contributing to the accident was pilot's intentional abrupt maneuvering at a low altitude and the flaps that retracted a knotch.NTSB SEA91LA204Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sunriver, ORThe pilot's inadequate compensation for wind conditions, which resulted in a failure to maintain runway alignment. The gusty crosswind was a related factor.NTSB NYC91FA097Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Muncie Valley, PAThe pilot's attempt to maintain visual flight into known instrument meteorological conditions, resulting in a collision with trees. Factors related to the accident were: the pilot's failure to obtain a pre-flight weather briefing and his failure to maintain…NTSB MIA91LA195Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Gainesville, FLA loss of engine power for undetermined reasons and a lack of suitable terrain for a forced landing.NTSB LAX91LA350Accident · No injuriesLimited investigationFinal reportCessna 402C · Grand Canyon, AZThe failure of the airport operator to develop animal control procedures for the airport property.NTSB FTW91FA144Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Midland, TXThe pilot's inability to control the airplane due to his physiological incaapacitation. A factor was the pilot's impairment due to the usage of pain medications.NTSB CHI91LA258Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Delavan, WIMisjudged fuel consumption calculations by the pilot which resulted in fuel exhaustion. A factor related to the accident was refueling not performed.NTSB CHI91DER13Accident · No injuriesFinal reportBell 47G-3B-1 · Maple Grove, MNThe pilot's failure to maintain directional control of the helicopter during the forced landing. Related factors are the loss of engine power, loss of rotor RPM, the eroded compressor blades, the pilot's operation with known deficiencies in equipment and…NTSB ANC91LA121Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was the pilot's weather evaluation misjudgment, the high wind, and rough water encountered during takeoff.NTSB MIA91LA194Accident · Minor injuriesLimited investigationFinal reportSchultz Avid Flyer 502 · O'Brien, FLThe pilot in command's improper planned final approach, which resulted in an in flight collision with an electrical service line, and in flight collision with terrain.NTSB FTW91IA143Incident · No injuriesIncident investigationFinal reportBell 412 · Rowan MidlandThe mechanic's failure to assemble the tail rotor drive shaft correctly and the subsequent failure of the tail rotor drive shaft. A factor was the lack of inspection procedures for offshore maintenance.NTSB ANC91LA118Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Emmonak, AKThat the pilot inadvertently retracted the landing gear during the takeoff roll. Contributing to this accident was that the checklist was not followed.NTSB ANC91LA117Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Seward, AKThe pilot-in-command's (PIC) failure to maintain airspeed while maneuvering at a low altitude. Contributing to the accident was the high terrain.NTSB NYC91LA209Accident · Serious injuriesLimited investigationFinal reportCameron V-77 · New Middletown, OHThe unfavorable wind (shift) encountered by the balloon during the initial takeoff climb.