NTSB investigations, MD
11 cases where NTSB found Engine (reciprocating).
Cases per year
| 2013 | 1 |
|---|---|
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2024 | 1 |
Where
Latest cases
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.\"eventStateOrRegion\" = 'MD' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010585'))
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."eventStateOrRegion" = 'MD' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010585')) 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 ERA25LA004Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Parsonsburg, MDA total loss of engine power for reasons that were not determined.NTSB ERA21LA289Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-23 · Easton, MDA total loss of left engine power and uncommanded feathering of the left propeller for reasons that could not be determined.NTSB ERA20LA341Accident · No injuriesClass 3 · LimitedFinal reportTecnam P92 · Centerville, MDThe fatigue failure of the No. 1 cylinder exhaust valve spring retainer due to air trapped in the lubrication system, which resulted in a total loss of engine power.NTSB ERA19LA267Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Berlin, MDThe malfunction of the No. 9 pushrod, which resulted in a total loss of engine power.NTSB ANC19LA034Accident · No injuriesClass 3 · LimitedFinal reportCessna 172RG · Ocean City, MDA partial loss of power due to the liberation or failure of the No. 2 cylinder's exhaust valve.NTSB ERA18LA181Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35B33 · Berlin, MDThe failure of the No. 3 cylinder exhaust valve, which resulted in the total loss of engine power during takeoff.NTSB ERA17LA246Accident · No injuriesClass 3 · LimitedFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Stevensville, MDThe fatigue failure of an exhaust valve spring retainer due to air trapped in the lubrication system, which resulted in a total loss of engine power.NTSB ERA16LA319Accident · Minor injuriesClass 3 · LimitedFinal reportGrumman G164 · Chestertown, MDLoss of engine power due to a failure of the No. 3 cylinder head, which resulted in a forced landing and collision with ground equipment.NTSB ERA15LA368Accident · No injuriesLimited investigationFinal reportCessna 150M · Mount Airy, MDThe in-flight fatigue failure of the No. 4 cylinder barrel, which resulted in a total loss of engine power.NTSB ERA15LA123Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Fort Meade, MDThe mechanic’s failure to detect the incorrect dry valve tappet clearances while troubleshooting ongoing engine issues, which resulted in partial loss of engine power during takeoff. Contributing to the partial loss of engine power was the mechanic's failure…NTSB ERA13FA325Accident · Serious injuriesField investigationFinal reportBeech 23 · Laurel, MDThe pilot's inadequate preflight preparation of the airplane, which resulted in a total loss of engine power during takeoff and his decision to operate the unairworthy airplane.