NTSB investigations, VT
4 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1982 | 1 |
|---|---|
| 1985 | 1 |
| 2000 | 1 |
| 2005 | 1 |
Where
Open the mapLatest 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\" = 'VT' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 352)
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" = 'VT' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 352) 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 IAD05LA090Accident · Serious injuriesLimited investigationFinal reportAeronca 11CC · Charlotte, VTThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall, and impact with terrain. A factor in the accident was the partial loss of engine power for undetermined reasons.NTSB NYC01LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-601P · S. Burlington, VTThe pilot's improper in-flight decision to perform a precautionary landing, and his failure to maintain airspeed after he experienced a partial loss of power on one engine. A factor was the partial loss of power on one engine due to an induction air leak.NTSB NYC85LA186Accident · No injuriesLimited investigationFinal reportPiper PA-18-95 · Stowe, VTDuring cruise flt, the plt heard a loud knocking coming from the eng and a decrease in oil pressure. During the landing in a fld, the landing gear collapsed and the acft ground looped. Examination of the eng disclosed that the hydraulic lifters of three of…NTSB NYC82FNC10Accident · No injuriesFinal reportPiper PA-24-180 · Woodstock, VTApproximately 5 min after departure the eng lost most of its oil pressure & started to lose power. The acft landed on a rough plowed field & the gear were torn off. The aluminum oil line that connects to the oil cooler broke off at the flare. The "b" nut was…