NTSB investigations
1,537 cases where the defining event was Unknown or undetermined.
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 WHERE c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '000') 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 WHERE c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '000') 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 ENG23WA028AccidentClass 5 · ForeignLearjet 35 · Hohn, GermanyNTSB GAA23WA147Accident · 2 fatalClass 5 · ForeignCessna 182 · Shell, EcuadorNTSB GAA23WA146Accident · 2 fatalClass 5 · ForeignEngineering & Research 415-C · St. Mary, JamaicaNTSB GAA23WA143Accident · 3 fatalClass 5 · ForeignRobinson R-44 · Shanxi, ChinaNTSB GAA23WA145Accident · No injuriesClass 5 · ForeignCirrus SR22 · Joanopolis, BrazilNTSB GAA23WA133Accident · 4 fatalClass 5 · ForeignPiper PA32 · Isla Mocha, ChileNTSB ERA23LA205Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C · Springfield, TNA partial loss of engine power for undetermined reasons.NTSB GAA23WA135AccidentClass 5 · ForeignCessna 150 · St-Rémi-de-Laprairie, FranceNTSB WPR23FA153Accident · 2 fatalClass 3 · FieldFinal reportMullins David J JR Glastar · Cal-Nev-Ari, NVThe pilot's failure to maintain sufficient altitude for undetermined reasons while maneuvering to land in dark night conditions, which resulted in collision with terrain.NTSB ERA23LA190Accident · No injuriesClass 3 · LimitedFinal reportCessna 172H · Charles Town, WVA loss of engine power for undetermined reasons.NTSB GAA23WA120Accident · 2 fatalClass 5 · ForeignPiper PA28 · Prosperpine, AustraliaNTSB CEN23LA145Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Lincoln, ILA total loss of engine power during an approach for landing for undetermined reasons.NTSB CEN23FA144Accident · 1 fatalClass 3 · FieldFinal reportZenith Stol CH701 · Oxford, MSAn in-flight collision with trees and terrain for undetermined reasons.NTSB GAA23WA100Accident · 2 fatalClass 5 · ForeignDiamond DA40 · Gondia, IndiaNTSB ERA23LA156Accident · No injuriesClass 3 · LimitedFinal reportBeech V35 · Shoreham, NYA total loss of engine power for unknown reasons.NTSB ANC23LA027Accident · No injuriesClass 3 · LimitedFinal reportCessna 182R · Minto, AKA total loss of engine power for reasons that could not be determined.NTSB GAA23WA093Accident · 1 fatalClass 5 · ForeignRobinson 44 · Boro Area, Okavango Delta, BotswanaNTSB ERA23LA148Accident · Serious injuriesClass 3 · LimitedFinal reportVelocity Velocity SE · Bahia Key, FLA total loss of engine power for undetermined reasons.NTSB DCA23WA225Incident · No injuriesClass 5 · ForeignBoeing 737 · Nuremberg, GermanyNTSB WPR23FA143Accident · 1 fatalClass 3 · FieldFinal reportCessna T182T · Queets, WAThe pilot’s failure to maintain clearance from terrain for undetermined reasons.NTSB WPR23LA121Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · San Andreas, CAA loss of engine power for undetermined reasons.NTSB CEN23LA136AccidentClass 4 · LimitedFinal reportCessna 150F · Hillsboro, TXSubstantial damage for reasons undetermined based on the available evidence.NTSB GAA23WA087Accident · 2 fatalClass 5 · ForeignCessna 208 · Nakina, CanadaNTSB ERA23LA133Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-12 · Ebeemee Township, MEA partial power loss of engine power during initial climb for undetermined reasons.NTSB ERA23FA130Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Duluth, MNA rapid descent and subsequent collision with terrain for reasons that could not be determined based on the available evidence.NTSB GAA23WA081AccidentClass 5 · ForeignBeech 1900 · Winnipeg, CanadaNTSB CEN23LA114Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Venus, TXThe loss of engine power for undetermined reasons.NTSB GAA23WA082Accident · 1 fatalClass 5 · ForeignRobinson 44 · Xian, ChinaNTSB GAA23WA073AccidentClass 5 · ForeignCessna 340 · Mount Mayon, PhilippinesNTSB ANC23LA023Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P337H · Kona, HIThe failure of the pilot to recognize that the rear engine was not operating during takeoff, which resulted in an attempted single-engine takeoff and the airplane’s subsequent descent and impact with terrain. Contributing to the accident was a loss of rear…NTSB CEN23LA106Accident · No injuriesClass 3 · LimitedFinal reportJabiru USA Sport J250-SP · Cortland, ILA total loss of engine power for reasons that could not be determined.NTSB GAA23WA099Accident · No injuriesClass 5 · ForeignCessna 208B · Puente de Ixtla, MexicoNTSB WPR23LA107Accident · Minor injuriesClass 3 · LimitedFinal reportBell OH-58A · Yuma, AZA total loss of engine power for reasons that could not be determined.NTSB WPR23LA104Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F35 · Gladewater, TXThe loss of engine power for undetermined reasons.NTSB WPR23LA098Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210N · Murrieta, CAA loss of engine power during the turn from base to final for undetermined reasons. Contributing to the accident was the pilot’s decision to not maintain traffic pattern altitude, which resulted in the off-airport landing.NTSB GAA23WA091Accident · 6 fatalClass 5 · ForeignCessna 206 · Barangay Ditarum, PhilippinesNTSB CEN23LA088Accident · No injuriesClass 3 · LimitedFinal reportBeech M35 · Tomball, TXA loss of engine power during cruise flight for undetermined reasons.NTSB ERA23LA111Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-160 · Somerville, TNBased on available evidence, the reason for the damage to the airplane’s propeller and engine cowling could not be determined.NTSB CEN23LA076Accident · No injuriesClass 3 · LimitedFinal reportCessna 182M · Council Bluffs, IAThe partial loss of engine power for reasons that could not be determined.NTSB GAA23WA062Accident · 2 fatalClass 5 · ForeignSling 4 TSI · Meyerton, South AfricaNTSB ENG23WA013Accident · 2 fatalClass 5 · ForeignBombardier CL600 · Venado, MexicoNTSB ERA23LA093Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Annapolis, MDA reported partial loss of engine power for undetermined reasons.NTSB CEN23LA066Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Harrison, ARA loss of engine power for reasons that could not be determined.NTSB WPR23LA060Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 177 · Willow Spring, AZThe airplane’s loss of engine power for undetermined reasons.NTSB CEN23LA049Accident · No injuriesClass 3 · LimitedFinal reportCessna 182A · Durango, COA complete loss of engine power for reasons that could not be determined from the available evidence.NTSB ERA23LA068Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Manassas, VAA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN23FA038Accident · 1 fatalClass 3 · FieldFinal reportCessna 421C · Decatur, TXA loss of power on the left engine due to fuel starvation and the subsequent loss of power on the right engine for undetermined reasons.NTSB GAA23WA037Accident · 1 fatalClass 5 · ForeignRobinson R22 · Ramingining, AustraliaNTSB GAA23WA026AccidentClass 5 · ForeignBeech 33 · San Felipe, VenezuelaNTSB GAA23WA060Accident · 2 fatalClass 5 · ForeignAirbus AS350 · Trøndelag county, Norway