NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 WPR10FA383Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Phoenix, AZThe pilot‘s failure to maintain airspeed and airplane control during a turn from the base leg to final approach due to his diverted attention.NTSB WPR10CA398Accident · Serious injuriesData collectionFinal reportKirkpatrick Buzzard · Lincoln, CAA loss of control due to the mechanical disconnection of an aileron pushrod from its bellcrank as a result of the mechanic's failure to properly secure the pushrod attach hardware. Also causal was the pilot's inadequate preflight inspection.NTSB ERA10LA401Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Donalsonville, GAA total loss of engine power due to a failure of the compressor turbine blades for undetermined reasons.NTSB ERA10CA399Accident · No injuriesData collectionFinal reportSchweizer 269C · Baldwin, FLA loss of tail rotor effectiveness during a hover.NTSB ENG10IA045Incident · No injuriesIncident investigationFinal reportBell 430 · Venice, LAThe fracture of the collective servo actuator piston rod resulting from stress corrosion cracking.NTSB DCA10IA082Incident · Minor injuriesIncident investigationFinal reportBoeing 767-322 · Chicago, ILthe brake fire after landing was caused by hydraulic fluid leaking on to hot brakes.NTSB CEN10LA459Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth VENTUS-2B · Batesville, TXBoth glider pilots' inability to see and avoid the other resulting in a mid-air collision.NTSB CEN10FA458Accident · 3 fatalField investigationFinal reportBeech C35 · Rollinsville, COA loss of engine power for undetermined reasons.NTSB CEN10CA464Accident · No injuriesData collectionFinal reportCessna 414 · Vici, OKThe pilot's failure to ensure adequate runway remaining during landing.NTSB ERA10LA395Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Blossvale, NYA total loss of engine power for undetermined reasons.NTSB CEN10CA468Accident · No injuriesData collectionFinal reportPiper J3C-85 · Auburn, INThe pilot of the other airplane failing to monitor the position this airplane.NTSB WPR10LA381Accident · 2 fatalLimited investigationFinal reportAdvertising Mgmt & Consulting Velocity Super XLRG5 · San Diego, CAThe pilot did not close and secure the right passenger door, which resulted in an in-flight separation of the door and subsequent loss of engine power due to the door’s collision with the rear-mounted engine assembly.NTSB WPR10CA380Accident · No injuriesData collectionFinal reportPiper PA-12 · White Sulphur Springs, MTThe pilot’s loss of directional control while attempting to avoid a herd of antelope crossing the runway during the landing rollout.NTSB ERA10LA396Accident · No injuriesLimited investigationFinal reportCessna 177B · Mashpee, MAThe pilot’s delayed use of carburetor heat while flying at reduced power settings in conditions that were favorable for carburetor icing resulting in the partial loss of engine power.NTSB ERA10LA391Accident · 1 fatalLimited investigationFinal reportTurck G L/Duflo J T SEA REY · Winter Haven, FLThe pilot's failure to maintain adequate airspeed on approach for landing, resulting in an inadvertent stall/spin and collision with water.NTSB ERA10FA403Accident · 2 fatalField investigationFinal reportRobinson Helicopter R44 II · Blairsville, GAThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB ERA10CA393Accident · No injuriesData collectionFinal reportMaule M-7-260 · Onset, MAThe pilot's loss of airplane control during the initial climb.NTSB CEN10LA457Accident · No injuriesLimited investigationFinal reportCessna 180B · Burnet, TXThe failure of the tailwheel compression spring, which resulted in a loss of directional control during landing.NTSB CEN10CA461Accident · No injuriesData collectionFinal reportWing Kitfox II · Park Rapids, MNA partial loss of engine power for undetermined reasons and the pilot's failure to adequately flare during the water landing.NTSB CEN10CA451Accident · No injuriesData collectionFinal reportPiper PA-12 · Wild Rose, WIThe pilot's loss of directional control during the takeoff roll.NTSB WPR10CA428Accident · No injuriesData collectionFinal reportHolmgreen John B RV8A · Carlsbad, CAThe pilot’s inadequate pretakeoff checks and failure to maintain control during the takeoff roll. Contributing to the accident was the pilot’s diverted attention due to the open canopy.NTSB ERA10LA390Accident · 1 fatalLimited investigationFinal reportCessna A185F · Rockwood, METhe pilot's failure to retract the landing gear prior to a water landing. Contributing to the accident was the pilot's impairment due to medication.NTSB ERA10LA389Accident · 1 fatalLimited investigationFinal reportCessna A185F · Newfane, NYThe pilot's failure to maintain aircraft control due to his diverted attention, which resulted in a collision with trees during the initial climb after takeoff. Contributing to the accident was the passenger's attempt to secure the jump door after it opened…NTSB ERA10CA397Accident · No injuriesData collectionFinal reportLuscombe 8C · Zelienople, PAThe pilot's loss of directional control while taking off with a gusting wind.NTSB ERA10CA388Accident · Minor injuriesData collectionFinal reportCessna 177B · Middleberry, VTThe pilot’s delayed decision to abort the takeoff.NTSB CEN11CA018Accident · Minor injuriesData collectionFinal reportCessna 172M · Newton, KSThe pilot’s inadequate flare, which resulted in a hard landing.NTSB CEN10LA449Accident · No injuriesLimited investigationFinal reportCessna 172P · Santa Fe, NMA total loss of engine power following a loss of oil pressure for undetermined reasons.NTSB CEN10IA453Incident · No injuriesIncident investigationFinal reportPiper PA-32R-301T · Mount Pleasant, TXThe failure of an aileron control cable due to a seized idler pulley bearing.NTSB ANC10FA067Accident · 3 fatalField investigationFinal reportFairchild C-123K · McKinley Park, AKThe pilot's failure to maintain adequate airspeed to avoid a low altitude stall, resulting in a loss of control and collision with terrain.NTSB WPR10LA377Accident · 1 fatalLimited investigationFinal reportGlaser Dirks DG300 · Morgan, UTThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in a stall/spin and ground impact.NTSB WPR10LA376Accident · No injuriesLimited investigationFinal reportCessna 177 · Rawlins, WYThe pilot's inadequate preflight planning, failure to properly use the takeoff checklist, and failure to lean the fuel mixture, which resulted in the airplane’s inability to attain sufficient airspeed due to the rich fuel mixture.NTSB WPR10CA382Accident · No injuriesData collectionFinal reportBoeing PT-13B · Santa Rosa, CAThe failure of the pilot of another airplane to maintain clearance while taxiing.NTSB WPR10CA378Accident · No injuriesData collectionFinal reportPorter James Grant Superior CUB · Caldwell, IDThe pilot’s failure to maintain directional control during landing.NTSB ERA10CA392Accident · No injuriesData collectionFinal reportCessna 172N · Elk Creek, VAThe student pilot’s continued visual flight into instrument meteorological conditions, which resulted in an off-airport landing.NTSB CEN10LA455Accident · Serious injuriesLimited investigationFinal reportGarlick OH-58A · Kountze, TXA loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel planning.NTSB CEN10FA448Accident · 2 fatalField investigationFinal reportAmerican Champion Aircraft Cor 7GCBC · Midlothian, TXThe flight instructor’s incapacitation due to preexisting but unrecognized coronary disease, and the student pilot’s distraction and inability to recover the airplane from a stall/spin at low altitude.NTSB ERA10LA387Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33AK · Windsor, VAThe unauthorized installation of a battery and associated wiring and electrical components, which resulted in an in-flight electrical fire of undetermined origin.NTSB ERA10CA402Accident · No injuriesData collectionFinal reportCessna 172N · Perry, GAThe pilot's failure to maintain clearance from a pole while taxiing.NTSB ENG10WA048Incident · No injuriesForeign investigationBoeing 747 · Pacific OceanNTSB CEN10CA467Accident · No injuriesData collectionFinal reportCessna 152 · Breckenridge, MIThe pilot's failure to mantain directional control during the aborted landing.NTSB CEN10CA456Accident · No injuriesData collectionFinal reportLindstrand 69A · Longview, TXThe the pilot's inadvertent movement of the burner assembly off center resulting in an in-flight fire of the skirt and envelope of the balloon. Contributing to the accident was the pilot's attention being diverted to venting the envelope to avoid an obstacle…NTSB CEN10CA452Accident · No injuriesData collectionFinal reportMaule MX-7-180A · Pittsfield, ILThe pilot's loss of directional control during a precautionary off-field landing that he performed after encountering deteriorating weather conditions.NTSB ANC10CA066Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Fairbanks, AKThe pilot's failure to maintain directional control after encountering a crosswind during landing.NTSB WPR10FA373Accident · 1 fatalField investigationFinal reportMarshall CH601 HDS · Kapowsin, WAThe pilot’s failure to maintain adequate airspeed which resulted in a stall and loss of control during the initial climb.NTSB ERA10WA394Accident · 1 fatalForeign investigationBell Helicopter Textron Canada 206B · Libertad, UruguayNTSB ERA10LA385Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Canton, MSThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and spin.NTSB ERA10LA383Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Holly Hill, SCMaintenance personnel's improper inspection and cleaning of the fuel nozzle, which resulted in a total loss of engine power.NTSB CEN10LA450Accident · No injuriesLimited investigationFinal reportCessna T188C · Montezuma, INThe total loss of engine power due to an insufficient fastener preload that led to the failure of the No. 2 connecting rod assembly.NTSB CEN10CA460Accident · No injuriesData collectionFinal reportCessna T210M · Shell Lake, WIThe collision with the deer during landing roll.NTSB CEN10CA454Accident · No injuriesData collectionFinal reportPiper PA-36-285 · Petersburg, TXThe pilot's failure to maintain clearance from a signpost during an aerial application flight.