NTSB investigations, 2024
60 cases where the sequence of events included Powerplant sys/comp malf/fail.
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 year(c.\"eventDate\") = 2024
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '340' 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 year(c."eventDate") = 2024 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '340' 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 WPR24LA121Accident · No injuriesClass 3 · LimitedFinal reportKitfox Series 5 · Yucca Grove, CAThe pilot’s improper repair of the oil sump, which resulted in a loss of oil pressure and collision with terrain during a precautionary landing.NTSB CEN24LA140Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · San Saba, TXA total loss of engine power due to multiple connecting rod failures from oil starvation.NTSB GAA24WA105IncidentClass 5 · ForeignCessna 150 · Budaors, HungaryNTSB ANC24LA017Accident · Serious injuriesClass 3 · LimitedFinal reportMD Helicopter 369E/500E · Kekaha, HIMaintenance personnel’s noncompliance with maintenance manual procedures that required the removal of the overrunning clutch output bearing during the regreasing procedure, which resulted in inadequate regreasing of the bearing and the subsequent failure of…NTSB CEN24LA120Accident · Serious injuriesClass 3 · LimitedFinal reportPulsar I · Patterson, LAThe non-certificated pilot’s decision to operate an unairworthy engine, which led to cylinder failure and a loss of engine power.NTSB WPR24LA087Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20K · Burley, IDThe failure of the pilot to fly a stabilized approach during an emergency landing with a tailwind, which resulted in a bounced landing and subsequent runway excursion during the landing roll. Contributing to the accident was the pilot’s inadequate preflight…NTSB ERA24FA110Accident · 2 fatalClass 3 · FieldFinal reportBombardier CL-600-2B16 · Naples, FLCorrosion of both engines’ variable geometry (VG) system components, which led to their operation in an off-schedule position and resulted in near-simultaneous sub-idle rotating compressor stalls on approach, subsequent loss of thrust in both engines, and an…NTSB WPR24LA074Accident · No injuriesClass 3 · LimitedFinal reportBeck Michael J Sonex · Auburn, WAWater contamination within the fuel regulator air-reference system, which resulted in improper fuel metering and a loss of engine power during initial climb.NTSB WPR24LA076Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Colorado City, AZThe loss of engine power due to the failure of the No. 2 piston pin plug, which resulted in oil starvation and subsequent failure of the No. 3 connecting rod. Contributing to the accident was the inadequate engine inspections by maintenance personnel.NTSB CEN24LA088Accident · Minor injuriesClass 3 · LimitedFinal reportEurocopter AS 350 B2 · Spofford, TXThe fatigue failure of the fuel control unit control lever arm, which resulted in fuel starvation, and a loss of engine power.