NTSB investigations, ME
9 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1983 | 1 |
|---|---|
| 1992 | 1 |
| 1997 | 1 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 2 |
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\" = 'ME' 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\" = 354)
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" = 'ME' 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" = 354) 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 IAD04IA032Incident · No injuriesIncident investigationFinal reportAviat A-1A · Fryeburg, METhe pilot's improper use of carburetor heat, which resulted in a loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB NYC04LA122Accident · No injuriesLimited investigationFinal reportGarlick Helicipters OH-58A · Columbia, MEA partial loss of engine power for undetermined reasons, which resulted in a forced landing during cruise flight.NTSB NYC03FA129Accident · 2 fatalField investigationFinal reportCessna 150H · Pittsfield, METhe inadvertent resumption of power during a forced landing that resulted in a subsequent spin. Factors related to the accident were the CFI's delayed remedial action, the loss of engine power due to contaminated fuel, an obstructed fuel screen, and the…NTSB IAD02LA041Accident · No injuriesLimited investigationFinal reportCessna U206F · Matinicus, MEA partially blocked fuel metering unit inlet screen, which resulted in a partial loss of engine power. Also causal, was the operator's lack of inlet screen inspection procedures.NTSB NYC01LA184Accident · No injuriesLimited investigationFinal reportPohl Lancair IV-P · Fryeburg, MEA partial blockage of the air intake system, due to the pilot's failure to ensure the engine compartment was clear of paper towels after a maintenance inspection.NTSB IAD01LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Ashland, MEloss of partial engine power due to carburetor icing.NTSB IAD97LA050Accident · No injuriesLimited investigationFinal reportCessna 150 · Turner, MELoss of engine power for undetermined reasons. A related factor was the snowbank.NTSB NYC92LA060Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-20 · Isle Au Haut, MEFuel system icing and contamination which resulted in a loss of engine power and subsequent stall and loss of control during a forced landing.NTSB NYC83FA172Accident · 2 fatalField investigationFinal reportPiper J3C-65S · Abbot Village, METhe acft was observed to depart a pond to the south & climb over trees when the eng lost power. The acft started a rightbank as if to return to the pond & stalled into the trees. One witness heard the eng restart just before the crash. The last annual…