NTSB investigations
1,709 cases where the sequence of events included 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 DCA23WA314Incident · No injuriesClass 5 · ForeignBoeing 717 · Cambridge, AustraliaNTSB ERA23FA256Accident · 4 fatalClass 3 · FieldFinal reportCessna 560 · Montebello, VAPilot incapacitation due to loss of cabin pressure for undetermined reasons. Contributing to the accident was the pilot’s and owner/operator’s decision to operate the airplane without supplemental oxygen.NTSB CEN23LA224Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Oklahoma City, OKA loss of engine power during approach for landing for undetermined reasons.NTSB ERA23FA254Accident · 1 fatalClass 3 · FieldFinal reportZenith 601XL · Albertville, ALA descent and impact with terrain for reasons that could not be determined.NTSB CEN23LA223Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502B · Lake Village, ARA reported loss of thrust for reasons that could not be determined.NTSB WPR23LA269Accident · Minor injuriesClass 3 · LimitedFinal reportCSP Leasing MTO Sport · Gardiner, MTFailure of the rudder/nosewheel steering system for reasons that could not be determined, which resulted in loss of yaw control and a subsequent rollover.NTSB ERA23LA251Accident · No injuriesClass 3 · LimitedFinal reportMagniflight M24 Orion Plus · Dauphin Island, ALA partial loss of engine power due to a loss of combustion in the No. 4 cylinder for undetermined reasons.NTSB CEN23LA221Accident · No injuriesClass 3 · LimitedFinal reportQuad City Challenger · Doniphan, MOA partial loss of engine power for undetermined reasons.NTSB WPR23LA198Accident · Minor injuriesClass 3 · LimitedFinal reportSilvaire Luscombe 8A · Clovis, NMThe airplane’s uncontrollable descent and forced landing for reasons that could not be determined.NTSB GAA23WA153Accident · 3 fatalClass 5 · ForeignAvions Robin DR400 · Les Ponts-de-Martel, SwitzerlandNTSB GAA23WA152Accident · 3 fatalClass 5 · ForeignCirrus SR20 · Mali Makovnik, CroatiaNTSB ERA23LA241Accident · Minor injuriesClass 3 · LimitedFinal reportBurril Benjamin D BDB001 · Wadesboro, NCA reported total loss of engine power and a subsequent forced landing for reasons that could not be determined because the pilot did not make the wreckage available for examination.NTSB ENG23WA028AccidentClass 5 · ForeignLearjet 35 · Hohn, GermanyNTSB WPR23FA185Accident · 3 fatalClass 3 · FieldFinal reportGates Lear Jet 36A · San Clemente Island, CAThe pilots’ loss of airplane control following a catastrophic fire that started on the left side of the aft equipment bay (tail cone). The fire likely initiated from a leak from the left fuel motive flow line due to a b-nut that loosened for reasons that…NTSB GAA23WA147Accident · 2 fatalClass 5 · ForeignCessna 182 · Shell, EcuadorNTSB GAA23WA146Accident · 2 fatalClass 5 · ForeignEngineering & Research 415-C · St. Mary, JamaicaNTSB CEN23LA169Accident · No injuriesClass 3 · LimitedFinal reportZenith Stol CH750 · Udall, KSThe pilot’s failure to maintain clearance from power lines. Contributing to the accident was the reported loss of engine power for reasons that could not be determined.NTSB 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 WPR23LA162Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Grand Canyon, AZThe airplane’s loss of engine power for undetermined reasons and the pilot’s exceedance of the airplane’s critical angle of attack and subsequent failure to maintain adequate airspeed, which resulted in an aerodynamic stall.NTSB 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 WPR23LA134Accident · No injuriesClass 3 · LimitedFinal reportHarris Robert W Zenith CH 801 · Brigham City, UTThe pilot’s improper flare, which resulted in a hard landing following a reported loss of engine thrust for undetermined reasons.NTSB 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 CEN23FA113Accident · 5 fatalClass 3 · FieldFinal reportBeech B200 · Little Rock, ARThe loss of control during initial climb for undetermined reasons. Contributing to the accident were the sudden wind shifts during the initial climb.NTSB 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.