NTSB investigations, ME
7 cases where NTSB found Not determined, general.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 2 |
| 2014 | 2 |
| 2015 | 1 |
| 2023 | 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '05000000'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '05000000')) 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 ERA23LA133Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-12 · Ebeemee Township, MEA partial power loss of engine power during initial climb for undetermined reasons.NTSB ERA15LA334Accident · Serious injuriesLimited investigationFinal reportBeech B19 · Dexter, METhe flight instructor’s inadequate preflight planning, which resulted in collision with trees and terrain during takeoff.NTSB ERA14LA378Accident · Minor injuriesLimited investigationFinal reportBirchler Boyd Eagle 540 · Standish, METhe total loss of engine power due to fuel starvation for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA14TA096Accident · No injuriesFinal reportEurocopter AS350B3 · Houlton, MEAn engine compartment explosion during takeoff; the origin of the explosion could not be determined during postaccident examination due to extensive fire damage.NTSB ERA10LA453Accident · No injuriesLimited investigationFinal reportCessna 120 · Rockland, METhe loss of engine power for undetermined reasons.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…NTSB ERA09LA433Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Livermore Falls, MEA loss of engine power for undetermined reasons.