NTSB investigations, ME
11 cases where NTSB found Performance/control parameters, general.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 2 |
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\", '01062000'))
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", '01062000')) 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 ERA17LA252Accident · No injuriesLimited investigationFinal reportCessna R172 · Naples, METhe pilot's failure to maintain airplane control during landing.NTSB ERA17CA213Accident · Minor injuriesData collectionFinal reportCessna 207 · Vinalhaven, METhe pilot’s failure to maintain a stabilized approach, which resulted in a bounced landing and subsequent go-around with insufficient distance to clear trees during the climb.NTSB ERA16LA247Accident · Minor injuriesLimited investigationFinal reportMormile Francis W Aventura II · West Pittsfield, METhe pilot's failure to maintain airplane control after a total loss of engine power due to carburetor icing, which accumulated because the carburetor heat was not functioning.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 ERA11LA336Accident · Serious injuriesLimited investigationFinal reportMarks Ca III Kitfox II · Scarborough, METhe pilot’s failure to maintain control of the airplane while taking off with a gusting wind.NTSB ERA11FA182Accident · 1 fatalField investigationFinal reportDiamond DA-40 · Allagash, METhe pilot's inadvertent encounter with icing conditions, which resulted in an aerodynamic stall and loss of control. Contributing was the pilots’ inadequate preflight weather planning.NTSB ERA10LA408Accident · No injuriesLimited investigationFinal reportQuest Kodiak 100 · Naples, MEA loss of control during landing for undetermined reasons.NTSB ERA09CA416Accident · Minor injuriesData collectionFinal reportMaule M7 · Turner, METhe pilot's failure to maintain aircraft control during the landing rollout.NTSB ERA09CA403Accident · Minor injuriesData collectionFinal reportSmith PA18 replica · Chesterville, METhe pilot's failure to maintain aircraft control while turning from base leg to final approach.NTSB NYC08FA155Accident · 1 fatalField investigationFinal reportSIAI-Marchetti SF-260 · Belfast, METhe pilot's failure to maintain control of the airplane due to spatial disorientation during an aerobatic maneuver.