NTSB investigations, ME
20 cases where the sequence of events included Nose over/nose down.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 4 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2017 | 2 |
| 2023 | 2 |
| 2025 | 3 |
| 2026 | 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\" = 'ME' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '096' 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."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '096' 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 ERA26FA310Accident · 1 fatalClass 3 · FieldPreliminary reportDiamond Aircraft Ind DA20-A1 · Bristol, MEOn August 20, 2026, about 1300 eastern daylight time, a Diamond Aircraft Ind Inc DA20-A1, N83RF, was substantially damaged when it was involved in an accident near Bristol, Maine. The pilot was fatally injured, and the pilot-rated passenger sustained minor…NTSB ERA25LA347Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170 · Eustis, METhe pilot’s failure to maintain control of the airplane during takeoff, which resulted in an inadvertent descent, contact with the water, and a subsequent nose over.NTSB ERA25LA304Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Rangeley, METhe pilot’s failure to maintain control of the airplane during landing, which resulted in a runway excursion and subsequent nose over.NTSB ERA25LA285Accident · No injuriesClass 4 · LimitedFinal reportCessna TU206 · Ellsworth, METhe pilot’s decision to operate the airplane with a known deficiency of the floats, which resulted in an accumulation of water in the forward compartments of the floats, a forward center of gravity, and subsequent nose over during a water landing.NTSB ERA24LA024Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Rangeley, METhe pilot’s failure to maintain directional control during the landing roll with a crosswind, after the right tailwheel spring separated.NTSB ERA23LA226Accident · No injuriesClass 4 · LimitedFinal reportSilvaire Luscombe 8F · Frenchville, METhe pilot's failure to maintain control of the airplane while landing in gusting wind conditions.NTSB ERA17LA307Accident · Minor injuriesClass 3 · LimitedFinal reportCessna U206 · Harpswell, MEA total loss of engine power due to maintenance personnel's failure to apply proper torque to the cylinder flange nuts and through bolts, which resulted in shifting of the Nos. 1, 2, and 3 main bearings, loss of lubrication, and failure of the crankshaft.NTSB GAA17CA175Accident · No injuriesData collectionFinal reportCessna 172 · Greenville, METhe pilot's failure to maintain directional control while taxiing in gusting crosswind conditions.NTSB GAA15CA068Accident · No injuriesData collectionFinal reportCessna 180 · Hartland, MEAbnormal runway contact which precipitated a loss of control and nose-over.NTSB ERA14CA188Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Bethel, METhe pilot's failure to maintain control of the airplane while taxiing after landing during gusty wind conditions.NTSB ERA13LA151Accident · No injuriesLimited investigationFinal reportCessna 150 · Naples, METhe student pilot’s improper decision to land on a frozen lake.NTSB ERA12CA502Accident · No injuriesData collectionFinal reportMaule M-4C · Lincoln, METhe pilot's failure to maintain directional control during the landing roll.NTSB ERA11CA420Accident · No injuriesData collectionFinal reportDehavilland Tiger Moth DH 82A · Rockland, METhe pilot's failure to maintain a proper approach path during landing.NTSB ERA10LA390Accident · 1 fatalLimited investigationFinal reportCessna A185F · Rockwood, METhe pilot's failure to retract the landing gear prior to a water landing. Contributing to the accident was the pilot's impairment due to medication.NTSB ERA09LA457Accident · Serious injuriesLimited investigationFinal reportTidd Wesley Mini-Max · Hodgdon, METhe pilot's mismanagement of the fuel supply, which resulted in fuel starvation.NTSB ERA09CA416Accident · Minor injuriesData collectionFinal reportMaule M7 · Turner, METhe pilot's failure to maintain aircraft control during the landing rollout.NTSB ERA09LA397Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Auburn, MEA loss of engine power due to fuel contamination. Contributing to the accident was the inadequate maintenance inspection of the airplane and engine's fuel system.NTSB ERA09CA252Accident · No injuriesData collectionFinal reportCessna/Air Repair 305F · Embden, METhe pilot's failure to obtain the proper touchdown point while landing.NTSB NYC08CA153Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Lincoln, METhe pilot-rated-passenger's failure to maintain directional control during takeoff.NTSB NYC08CA101Accident · No injuriesData collectionFinal reportCessna 182K · Greenville, METhe pilot's failure to maintain directional control during the landing roll. Contributing to the accident were the snow covered runway and sun glare light conditions.