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 CEN23LA076Accident · No injuriesClass 3 · LimitedFinal reportCessna 182M · Council Bluffs, IAThe partial loss of engine power for reasons that could not be determined.NTSB WPR23FA083Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-34-220T · New Harmony, UTThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in a loss of airplane control due to spatial disorientation.NTSB ERA23LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Opa-locka, FLThe flight instructor’s decision to taxi behind a large multi-engine airplane, which resulted in an encounter with propeller blast and a loss of airplane control on the ground.NTSB ERA23LA101Accident · No injuriesClass 4 · LimitedFinal reportCessna 340A · Atlantic Ocean, Turks & Caicos IslandsA fuel system malfunction for reasons that could not be determined, which resulted in fuel starvation to both engines.NTSB ENG23WA009IncidentClass 5 · ForeignBoeing 767 · Incheon, South KoreaNTSB CEN23LA075Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Yukon, OKThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR23FA080Accident · 1 fatalClass 3 · FieldFinal reportEmbraer Executive EMB-505 · Provo, UTThe pilot’s failure to deice the airplane before takeoff in weather conditions conducive to ice accumulation, which resulted in an ice-contaminated wing and subsequent stall during takeoff.NTSB GAA23WA063AccidentClass 5 · ForeignEurocopter EC130 B4 · Gold Coast, AustraliaNTSB GAA23WA062Accident · 2 fatalClass 5 · ForeignSling 4 TSI · Meyerton, South AfricaNTSB GAA23WA049Accident · No injuriesClass 5 · ForeignCessna F152 · Shoreham on the Sea, United KingdomNTSB DCA23LA114Accident · No injuriesClass 4 · LimitedFinal reportBombardier CL-600-2D24 · New York, NYITA Airways flight crew's incorrect evaluation of the clearance between their airplane and another airplane stopped on an adjoining taxiway.NTSB ANC23LA011Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Kenai, AKThe pilot's failure to maintain directional control during landing in flat light conditions, resulting in the airplane to nose over.NTSB WPR23LA082Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Watsonville, CAThe pilot’s failure to maintain clearance from powerlines during a go around.NTSB GAA23WA053AccidentClass 4 · ForeignCessna 152 · Madhya Pradesh, IndiaNTSB ERA23LA107Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-301T · Old Bridge, NJThe pilot’s failure to maintain adequate clearance from trees during the landing approach.NTSB CEN23LA073Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Conway, ARThe solo student pilot’s improper landing flare and subsequent improper recovery from a bounced landing.NTSB GAA23WA050AccidentClass 5 · ForeignAir Tractor AT802 · Galvarino, ChileNTSB GAA23WA048Accident · 2 fatalClass 5 · ForeignChampion 7GCBC · Prijedori, Bosnia & HerzegovinaNTSB DCA23LA109Accident · 1 fatalClass 3 · LimitedFinal reportEmbraer S A ERJ 170-200 LR · Montgomery, ALThe ramp agent’s cognitive impairment, which resulted in her (1) inconsistent behavior with trained procedures and pre landing briefings, (2) presence on the left side of the airplane while the left engine was still operating, and (3) subsequent ingestion…NTSB ERA23LA100Accident · No injuriesClass 3 · LimitedFinal reportFoutz Robert V Cozy Mark IV · Dublin, VAA fire of undetermined origin during an attempted engine restart while taxiing.NTSB ENG23WA013Accident · 2 fatalClass 5 · ForeignBombardier CL600 · Venado, MexicoNTSB GAA23WA047Incident · No injuriesClass 3 · ForeignCessna 750 · Rionegro, ColombiaNTSB ERA23LA097Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA24 · Athens, GAThe pilot’s failure to detect water in the fuel during the preflight inspection, which resulted in a loss of engine power.NTSB CEN23FA071Accident · 4 fatalClass 3 · FieldFinal reportBell 407 · Galliano, LAThe pilot’s failure to ensure the helicopter was clear of obstacles before takeoff from the helideck, which resulted in the helicopter’s right landing skid pivoting about a helideck perimeter light during takeoff and a dynamic rollover. Additionally, the…NTSB WPR23LA081Accident · No injuriesClass 4 · LimitedFinal reportEmbraer Executive EMB-505 · Hawthorne, CAA runway overrun due to the pilot’s failure to stop the airplane as a result of diminished braking action due to a water contaminated runway surface.NTSB WPR23LA078Accident · Serious injuriesClass 3 · LimitedFinal reportAirbus Helicopters EC 130 T2 · Boulder City, NVThe pilot’s failure to apply anti-torque pedal input in a sufficient, timely, and sustained manner while attempting to arrest a turn during a hover-taxi, which resulted in a loss of directional control. Contributing to the severity of the occupants’ injuries…NTSB GAA23WA084Accident · 1 fatalClass 5 · ForeignSocata TB21 · Saint-Pons, FranceNTSB ERA23LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Ethel, WVThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion.NTSB GAA23WA097Accident · 1 fatalClass 5 · ForeignCessna 310F · Puerto Vallarta, MexicoNTSB DCA23WA102OccurrenceClass 5 · ForeignBoeing 737 · Dunavecse, HungaryNTSB CEN23LA072Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Brookshire, TXThe P51 pilot’s failure to see and avoid the PA46 during taxi operations.NTSB WPR23LA076Accident · No injuriesClass 3 · LimitedFinal reportCessna 210N · Morgan, UTFailure of the brake system O-rings on the left landing gear trunnion, which allowed the hydraulic fluid to drain from the left brake system, resulting in a runway excursion and impact with a fence.NTSB WPR23LA075Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Payson, AZThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.NTSB GAA23WA076Accident · 2 fatalClass 5 · ForeignBanus Mark Glasair Super II FT · Wedderburn, AustraliaNTSB ERA23LA095Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ECA · Hampton, NHThe pilot’s failure to maintain directional control of the airplane while landing in crosswind conditions, which resulted in a runway excursion.NTSB ERA23LA094Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177 · Franklin, VAThe pilot’s failure to maintain clearance from trees during the initial climb following an aborted precautionary landing. Contributing to the outcome were the inoperative runway lights, which reduced the likelihood that the pilot could successfully land the…NTSB ERA23LA093Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Annapolis, MDA reported partial loss of engine power for undetermined reasons.NTSB ENG23WA007Incident · No injuriesClass 4 · ForeignBoeing 737 · Mogadishu, SomaliaNTSB ENG23WA006Incident · No injuriesClass 4 · ForeignBoeing 737 · Mogadishu, SomaliaNTSB DCA23WA161Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Bremen, GermanyNTSB CEN23LA070Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BF · Navasota, TXThe student pilot failed to maintain directional control during landing.NTSB CEN23LA069Accident · No injuriesClass 4 · LimitedFinal reportCessna 150J · South St. Paul, MNThe student pilot’s failure to maintain directional control during the take-off roll with a snow and ice covered runway.NTSB WPR23LA077Accident · Serious injuriesClass 3 · LimitedFinal reportBeech V35B · Livermore, CAThe pilot’s inadvertent use of the mixture control instead of the throttle, which resulted in fuel starvation and the subsequent loss of engine power.NTSB GAA23WA051Accident · 2 fatalClass 5 · ForeignCessna 210N · Bulman, AustraliaNTSB ENG23WA008IncidentClass 3 · ForeignAirbus A320 · Guadalajara, MexicoNTSB DCA23LA107Accident · Serious injuriesClass 4 · LimitedFinal reportGulfstream Aerospace GIV-X (G450) · Miami, FLAn unanticipated encounter with convective induced turbulence from developing cumulus clouds below the flight path, which produced strong updrafts and downdrafts.NTSB WPR23FA073Accident · 1 fatalClass 3 · FieldFinal reportCessna 150A · Santa Monica, CAA failure of the No. 1 piston connecting rod bearing journal due to oil starvation for reasons that could not be determined, which resulted in a complete loss of engine power.NTSB GAA23WA112Incident · No injuriesClass 5 · ForeignBeecraft 200GT · Akureyri, IcelandNTSB GAA23WA046Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Brasnorte, BrazilNTSB GAA23WA045Accident · 2 fatalClass 5 · ForeignBell 412EP · Ocean, Mexico