NTSB investigations
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 WPR21FA353Accident · 2 fatalClass 3 · FieldFinal reportBeech S35 · Billings, MTThe pilot’s improper flare, which led to a hard landing, subsequent loss of control, and collision with trees.NTSB GAA21WA241AccidentClass 5 · ForeignVans RV8 · Hyvinkää, FinlandNTSB ERA22LA068Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Indian Trail, NCThe pilot’s failure to maintain airplane control during takeoff and initial climb. Contributing was the pilot’s physical limitation which caused an inadvertent application of left rudder.NTSB DCA22LA002Accident · No injuriesClass 4 · LimitedFinal reportBoeing 757-224 · Newark, NJThe nose high attitude on landing resulted in a tailstrike.NTSB WPR21LA365Accident · No injuriesClass 4 · LimitedFinal reportCessna 175A · Salem, ORThe pilot’s improper landing flare in a tailwind, which resulted in a hard landing and subsequent impact with terrain.NTSB GAA21WA262Incident · No injuriesClass 4 · ForeignSchweizer G164B · Trinta y Tres, UruguayNTSB ERA22LA048Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-31-350 · Fort Lauderdale, FLThe collapse of the left main landing gear for reasons that could not be determined.NTSB ERA21FA377Accident · 3 fatalClass 3 · FieldFinal reportBeech C23 · Lansing, WVThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to avoid trees and terrain after takeoff, which resulted in an aerodynamic stall and loss of control. Also causal was the pilot’s decision to operate the airplane outside of…NTSB CEN21LA458Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182E · Troup, TXThe pilot’s failure to maintain directional control during landing with a variable gusting wind and his decision not to perform a go-around that resulted an overrun and impact with a fence and trees.NTSB ANC21LA097Accident · No injuriesClass 4 · LimitedFinal reportCessna 180E · Kotzebue, AKThe pilot’s loss of control during takeoff due to a gusty, variable wind and the rough terrain.NTSB WPR21LA361Accident · No injuriesClass 4 · LimitedFinal reportMaule MX-7-180A · Elk River, IDThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with a fence.NTSB WPR21LA355Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Tucumcari, NMThe pilot’s improper landing flare which resulted in a hard and bounced landing.NTSB GAA22WA005Accident · Serious injuriesClass 5 · ForeignGrumman AA5 · Teeside, United KingdomNTSB ERA21LA392Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-16 · Greensboro, GAThe pilot’s inadequate preflight planning and fuel system inspection, which resulted in fuel exhaustion.NTSB ENG21WA045Incident · No injuriesClass 5 · ForeignSikorsky S92 · North Sea, NorwayNTSB CEN21LA456Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Patterson, LAThe pilot’s failure to maintain adequate clearance from a parked helicopter while hovering to reposition for takeoff.NTSB WPR21LA366Accident · No injuriesClass 4 · LimitedFinal reportSharp Ralph R Zenith Stol CH 701 · Bishop, CAA loss of airplane control for undetermined reasons.NTSB GAA21WA239AccidentClass 5 · ForeignPiper PA-38-112 · Buenos Aires, ArgentinaNTSB GAA21WA235Accident · 2 fatalClass 5 · ForeignPiper PA18S · Ferme Neuve, CanadaNTSB CEN21LA457Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · Lancaster, OHThe loss of engine power due to fuel starvation.NTSB CEN21LA454Accident · No injuriesClass 4 · LimitedFinal reportKitfox IV · Ozark, ARThe pilot’s inability to maintain altitude after the airplane encountered a downdraft while he intentionally flew at a low-altitude during a practice for a short-takeoff-and-landing flight competition.NTSB WPR21LA356Accident · Minor injuriesClass 4 · LimitedFinal reportKitfox S7 · Hooper, UTThe pilot’s excessive brake pressure which resulted in the airplane nosing over and coming to rest inverted.NTSB WPR21LA354Accident · No injuriesClass 3 · LimitedFinal reportHiller UH-12E · Bovill, IDA loss of helicopter control for undetermined reasons based on the available evidence for this accident.NTSB GAA21WA246Accident · Serious injuriesClass 5 · ForeignPartenavia P68 · Bush Bay Beach, Co. Wexford, IrelandNTSB ERA21LA382Accident · No injuriesClass 4 · LimitedFinal reportWyder Robert G Marquart MA-5 · Waycross, GAThe pilot’s inadequate fuel management, which resulted in a total loss of engine power on approach due to fuel starvation.NTSB DCA22LA004Accident · No injuriesClass 4 · LimitedFinal reportAirbus A321-271N · Honolulu, HIThe captain’s improper landing flare, which resulted in an excessive sink rate and subsequent hard landing.NTSB CEN21LA451Accident · Minor injuriesClass 4 · LimitedFinal reportChristen Industries A-1 · Eden Prairie, MNThe pilot’s failure to maintain directional control during the landing roll resulting in a ground loop.NTSB ANC21LA099Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Cordova, AKThe pilot’s failure to maintain control of the airplane after landing in gusty wind conditions.NTSB ANC21LA096Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-14 · Chickaloon, AKA total loss of engine power during takeoff for reasons that could not be determined based on the available information.NTSB WPR21FA352Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28R-200 · Page, AZThe pilot’s improper fuel planning for a cross-country flight, which resulted in fuel exhaustion and a total loss of engine power.NTSB WPR21LA351Accident · No injuriesClass 4 · LimitedFinal reportGeorge A. Thiel Just Aircraft Highlander · Monroe, WAThe in-flight malfunction of the throttle control pivot arm, which resulted in a total loss of engine power and the subsequent collision with terrain during the forced landing.NTSB WPR21LA349Accident · No injuriesClass 4 · LimitedFinal reportBeech D17S · San Diego / El Cajon, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll with a crosswind, which resulted in a runway excursion and subsequent collision with runway signage.NTSB ERA21LA376Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Unadilla, GAThe airplane's impact by a bird during the enroute portion of the flight.NTSB GAA21WA251Accident · No injuriesClass 4 · ForeignLearjet 35 · Lanseria, South AfricaNTSB GAA21WA243Accident · Minor injuriesClass 3 · ForeignKaman K1200 · Okuwa, JapanNTSB WPR21LA364Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Auburn, CAThe student pilot’s inadequate flare which resulted in a hard and bounced landing.NTSB WPR21LA348Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Grass Valley, CAThe pilot’s failure to attain a proper touchdown point on the runway while landing in gusting wind conditions, which resulted in a runway overrun. Contributing to the accident was the pilot’s distraction due to an electrical issue.NTSB GAA21WA232AccidentClass 5 · ForeignPiper PA28 · Leon, SpainNTSB ERA21LA370Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Walnut Cove, NCThe pilot’s failure to attain the proper touchdown point which resulted in a runway overrun, collision with an airport boundary fence, and a nose over event.NTSB CEN21LA447Accident · No injuriesClass 4 · LimitedFinal reportMorgan Sport Copter Vortex · Kingsland, TXThe pilot’s diverted attention which resulted in an inadvertent descent and subsequent collision with a lake.NTSB WPR21LA357Accident · Serious injuriesClass 3 · LimitedFinal reportFonville Swearingen SX300 · Buckeye, AZThe total loss of engine power due to the failure of the left magneto.NTSB WPR21LA350Accident · No injuriesClass 3 · LimitedFinal reportCessna 404 · Sheridan, WYThe pilot experiencing an episode of impaired behavior and incapacitation for reasons that could not be determined based on the available information.NTSB GAA21WA257AccidentClass 5 · ForeignPiper PA28 · Llico, ChileNTSB GAA21WA254IncidentClass 5 · ForeignRockwell International 112A · Bad Ragaz, SwitzerlandNTSB ENG21WA043IncidentClass 5 · ForeignBoeing 767-34AF · Bogota, ColombiaNTSB ENG21WA042IncidentClass 5 · ForeignBoeing 737 · Addis Ababa, NigeriaNTSB CEN21LA468Accident · Serious injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Beaumont, TXThe flight instructor’s failure to maintain aircraft control during the turn to final approach resulting in a rapid descent and impact with terrain.NTSB CEN21LA448Accident · No injuriesClass 4 · LimitedFinal reportCessna 305A · Topeka, KSThe loss of control and ground loop due to the mechanical malfunction of the tailwheel lock.NTSB CEN21LA446Accident · Serious injuriesClass 4 · LimitedFinal reportCole Paul B Challenger I · Higginsville, MOThe non-certificated pilot's exceedance of the airplane's critical angle of attack during a low-level turn, which resulted in an aerodynamic stall.NTSB CEN21FA426Accident · 1 fatalClass 3 · FieldFinal reportRans S20 · Wadsworth, OHThe pilot’s decision to depart shortly after a landing helicopter, which resulted in an encounter with the helicopter’s wake turbulence and a loss of airplane control. Contributing to the accident was the pilot’s impairment by his recent use of ethanol.