Fatal NTSB investigations, ME
7 cases where the sequence of events included Aerodynamic stall/spin.
Cases per year
| 2010 | 1 |
|---|---|
| 2011 | 2 |
| 2014 | 1 |
| 2018 | 1 |
| 2025 | 1 |
| 2026 | 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\" = 'ME' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '241' 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."eventStateOrRegion" = 'ME' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '241' 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 ERA26FA205Accident · 1 fatalClass 3 · FieldPreliminary reportCessna A185F · Avon, MEOn May 12, 2026, about 1058 eastern daylight time, a Cessna A185F airplane, N61368, was substantially damaged when it was involved in an accident near Avon, Maine. The pilot was fatally injured. The airplane was owned by the state of Maine and operated as a…NTSB ERA25FA332Accident · 1 fatalClass 3 · FieldPreliminary reportCzech Sport Sportcruiser · Fryeburg, MEOn September 4, 2025, about 1418 eastern daylight time, a Czech Sport Aircraft Sportcruiser, N336SC, was substantially damaged when it was involved in an accident near Fryeburg, Maine. The private pilot was fatally injured. The airplane was operated as a…NTSB ERA18FA206Accident · 3 fatalField investigationFinal reportPiper PA60 · Greenville, METhe pilot's exceedance of the airplane's critical angle of attack while maneuvering to land, which resulted in an aerodynamic stall.NTSB ERA14FA337Accident · 1 fatalField investigationFinal reportCulver LFA · Limington, METhe pilot’s failure to maintain airspeed during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB ERA12FA007Accident · 1 fatalField investigationFinal reportCessna 207A · Matinicus Island, METhe pilot’s failure to maintain airplane control during the approach after encountering a gusty crosswind, which resulted in an accelerated stall and uncontrolled descent.NTSB ERA11FA493Accident · 1 fatalField investigationFinal reportCessna 172M · Greenville, METhe pilot's failure to maintain adequate airspeed while manuevering at low altitude, which resulted in an aerodynamic stall/spin and subsequent impact with terrain.NTSB ERA10FA364Accident · 2 fatalField investigationFinal reportS.C. Aerostar Yak52 · South Portland, METhe pilot did not maintain adequate airspeed during an emergency return to the airport following a total loss of engine power, which resulted in an inadvertent stall. Contributing to the accident was a total loss of engine power for undetermined reasons and…