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 GAA24WA198Accident · 1 fatalClass 5 · ForeignCessna 310 · Yoro, HondurasNTSB WPR24FA213Accident · 1 fatalClass 3 · FieldFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Chamberino, NMAn aerodynamic stall and loss of control for reasons that could not be determined based on the available information.NTSB ERA24LA277Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Fire Island, NYA total loss of engine power for undetermined reasons.NTSB DCA24WA233Incident · No injuriesClass 5 · ForeignBoeing 737 · not reported, ThailandNTSB WPR24FA200Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Bluestem, WAThe pilot’s failure to manage main rotor rpm during an autorotation, which resulted in a loss of helicopter control. Contributing to the accident was a loss of power for reasons that could not be determined.NTSB ERA24LA267Accident · Minor injuriesClass 3 · LimitedFinal reportGarlick Helicopters OH-58A+ · Cisco, GAA reported total loss of engine power for reasons that could not be determined.NTSB ANC24FA052Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-18-150 · Moose Pass, AKOn June 18, 2024, about 1400 Alaska daylight time, a float-equipped Piper PA-18-150 airplane, N645DT, was substantially damaged when it was involved in an accident near Moose Pass, Alaska. The instructor pilot and the pilot receiving instruction were fatally…NTSB WPR24LA193Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Monument Hills, CAA total loss of engine power for reasons that could not be determined.NTSB GAA24WA187Accident · Serious injuriesClass 5 · ForeignRobinson R44 · Bilimbai, RussiaNTSB ANC24LA049Accident · Serious injuriesClass 3 · LimitedFinal reportDehavilland Beaver L-20A (DHC-2) · Port Alsworth, AKA partial loss of engine power for reasons that could not be determined.NTSB ERA24LA256Accident · Minor injuriesClass 3 · LimitedFinal reportZenith 701 · Ocala, FLThe pilot’s failure to maintain aircraft control and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and spin during an attempted go-around.NTSB ERA24LA241Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Terryville, CTA total loss of engine power for undetermined reasons.NTSB ENG24WA039AccidentClass 5 · ForeignTecnam P-Mentor · San Martin de Valdeiglesias, SpainNTSB WPR24LA160Accident · Minor injuriesClass 3 · LimitedFinal reportSteen Skybolt · Santa Maria, CAA total loss of engine power during approach for reasons that could not be determined.NTSB GAA24WA182Accident · 2 fatalClass 5 · ForeignMurphy Rebel · Squamish, CanadaNTSB GAA24WA177AccidentClass 5 · ForeignCessna 310 · Tegucigalpa, HondurasNTSB GAA24WA175Accident · 1 fatalClass 5 · ForeignCessna 182 · Kerestinec, CroatiaNTSB CEN24LA203Accident · No injuriesClass 3 · LimitedFinal reportPulsar Super Pulsar · Rochelle, ILA partial loss of engine power for undetermined reasons.NTSB ERA24FA219Accident · 1 fatalClass 3 · FieldPreliminary reportM-Squared Breese 2 · Culpeper, VAOn May 17, 2024, about 1430 eastern daylight time, an M-Squared Aircraft Inc. Breese 2 airplane, N99VY, was involved in an accident near the Culpeper Regional Airport (CJR), Culpeper, Virginia. The commercial pilot was fatally injured. The airplane was…NTSB GAA24WA171Accident · 2 fatalClass 5 · ForeignCessna 182 · Macas, EcuadorNTSB GAA24WA265Accident · Serious injuriesClass 5 · ForeignPiper PA32 · Cookshire-Eaton, CanadaNTSB GAA24WA178Accident · 3 fatalClass 5 · ForeignPiper PA28R · Barcarena, BrazilNTSB GAA24WA169Accident · 1 fatalClass 5 · ForeignPiper PA25 · Iracema, BrazilNTSB CEN24FA167Accident · 2 fatalClass 3 · FieldFinal reportVertical Aviation Technologies Hummingbird · Spring Branch, TXA total loss of engine power for undetermined reasons, which resulted in a forced landing and a subsequent impact with terrain.NTSB WPR24FA132Accident · 1 fatalClass 3 · FieldFinal reportBell 206-L4 · Anaconda, MTA total loss of engine power due to a loss of cooling oil to the turbine-to-compressor coupling shaft and subsequent fracture of the shaft at an altitude too low for the pilot to complete a successful autorotation. Contributing to the accident was carbon…NTSB DCA24WA191Incident · No injuriesClass 5 · ForeignAirbus A320 · Dublin, IrelandNTSB ANC24FA029Accident · 2 fatalClass 3 · FieldFinal reportDouglas C54D · Fairbanks, AKA loss of power of the No. 1 engine for reasons that could not be determined, and the incorrect installation of a B-nut fitting in the propeller feathering system, which allowed engine oil to spray onto the exhaust system when the propeller was feathered…NTSB WPR24LA127Accident · No injuriesClass 3 · LimitedFinal reportSchleicher Alexander ASH 26 E · Heber, UTReduced takeoff performance for reasons that could not be determined, which resulted in a forced landing.NTSB GAA24WA143Accident · 2 fatalClass 5 · ForeignExtra 300 · Tokol, Hungary, HungaryNTSB ERA24LA169Accident · No injuriesClass 4 · LimitedFinal reportSnyder Robert L Challenger II · Hendersonville, NCA loss of engine power for undetermined reasons.NTSB ERA24LA166Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Key Biscayne, FLA loss of engine power for reasons that could not be determined.NTSB CEN24FA148Accident · 3 fatalClass 3 · FieldFinal reportDavis DA-3 · Antlers, OKImpact with terrain for reasons that could not be determined.NTSB CEN24LA146Accident · No injuriesClass 3 · LimitedFinal reportSchweizer G-164B · Kaplan, LAA partial loss of engine power for reasons that could not be determined.NTSB GAA24WA134Accident · 1 fatalClass 5 · ForeignReims Cessna FR172F · Tyrol, AustriaNTSB GAA24WA159Accident · 1 fatalClass 5 · ForeignCessna 152 · Tolima, ColombiaNTSB ERA24LA161Accident · No injuriesClass 3 · LimitedFinal reportNavion Navion B · Sanford, FLA sudden loss of all engine power during takeoff for undetermined reasons.NTSB GAA24WA158Accident · 1 fatalClass 5 · ForeignPiper PA34 · Serra do Japi, BrazilNTSB GAA24WA136Accident · No injuriesClass 5 · ForeignBell 407 · Mwachon, KenyaNTSB GAA24WA166AccidentClass 5 · ForeignBell 407 · Raigad, IndiaNTSB GAA24WA103AccidentClass 3 · ForeignSikorsky S92 · Bergen, NorwayNTSB CEN24LA119Accident · Serious injuriesClass 3 · LimitedFinal reportZenith Stol CH750 · Sextonville, WIA loss of engine power for reasons that could not be determined, followed by a loss of control and subsequent impact with terrain.NTSB GAA24WA101Accident · 3 fatalClass 5 · ForeignRobinson R44 · Goianesia Do Para, BrazilNTSB ENG24WA011Accident · 2 fatalClass 5 · ForeignBlackshape BK160 · Kapar, MalaysiaNTSB GAA24WA097Accident · No injuriesClass 5 · ForeignAirbus Helicopters AS355 · Jawa Barat, IndonesiaNTSB GAA24WA086Accident · 1 fatalClass 3 · ForeignRobinson R44 · Lago Ranco, ChileNTSB CEN24LA107Accident · No injuriesClass 3 · LimitedFinal reportEdge 540 · La Porte, TXA loss of engine power after takeoff for undetermined reasons.NTSB CEN24LA104Accident · No injuriesClass 3 · LimitedFinal reportPiper PA24 · Cherokee, OKA partial loss of engine power for reasons that could not be determined. Contributing to the accident was the presence of ground fog, which hindered the landing approach and resulted in the pilot inadvertently landing long and impacting a fence during the…NTSB GAA24WA082Accident · No injuriesClass 5 · ForeignCessna 172 · Denholm, CanadaNTSB WPR24LA082Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-18A 150 · Eden, ORAn impact with terrain for undetermined reasons.NTSB GAA24WA084Accident · 2 fatalClass 5 · ForeignPiper PA24 · Sao Paulo, Brazil