NTSB investigations, 2001, ME
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1962 | 1 |
|---|---|
| 1964 | 27 |
| 1965 | 19 |
| 1966 | 34 |
| 1967 | 29 |
| 1968 | 38 |
| 1969 | 17 |
| 1970 | 13 |
| 1971 | 28 |
| 1972 | 40 |
| 1973 | 32 |
| 1974 | 23 |
| 1975 | 25 |
| 1976 | 26 |
| 1977 | 32 |
| 1978 | 25 |
| 1979 | 27 |
| 1980 | 21 |
| 1981 | 17 |
| 1982 | 18 |
| 1983 | 17 |
| 1984 | 22 |
| 1985 | 15 |
| 1986 | 16 |
| 1987 | 14 |
| 1988 | 15 |
| 1989 | 16 |
| 1990 | 12 |
| 1991 | 19 |
| 1992 | 20 |
| 1993 | 22 |
| 1994 | 19 |
| 1995 | 12 |
| 1996 | 14 |
| 1997 | 7 |
| 1998 | 10 |
| 1999 | 13 |
| 2000 | 12 |
| 2001 | 15 |
| 2002 | 10 |
| 2003 | 10 |
| 2004 | 12 |
| 2005 | 9 |
| 2006 | 14 |
| 2007 | 9 |
| 2008 | 13 |
| 2009 | 14 |
| 2010 | 10 |
| 2011 | 16 |
| 2012 | 11 |
| 2013 | 8 |
| 2014 | 8 |
| 2015 | 4 |
| 2016 | 7 |
| 2017 | 8 |
| 2018 | 4 |
| 2019 | 11 |
| 2020 | 6 |
| 2021 | 3 |
| 2022 | 5 |
| 2023 | 6 |
| 2024 | 9 |
| 2025 | 8 |
| 2026 | 9 |
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 year(c.\"eventDate\") = 2001
AND c.\"eventStateOrRegion\" = 'ME' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 2001 AND c."eventStateOrRegion" = 'ME' AND c."eventCountry" = 'USA' 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 IAD02LA021Accident · No injuriesLimited investigationFinal reportCessna 208B · Lewiston, METhe pilot's failure to adequately ensure the wings were free of contamination prior to departure. Factors included the operator's inadequate de-icing procedures and the snowy weather conditions.NTSB IAD02LA019Accident · Minor injuriesLimited investigationFinal reportPiper J3 · Livermore Falls, METhe pilot's failure to maintain proper altitude clearance while landing, which resulted in a collision with trees. A factor was the crosswind.NTSB NYC02LA023Accident · No injuriesLimited investigationFinal reportBeech 1900C · Bar Harbor, MEA deer, which had been crossing the runway as the airplane touched down. A factor was the dark night conditions.NTSB IAD02LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Phillips, MELoss of engine power due to a blockage of the left fuel tank vent line with mud, and the subsequent inadvertent stall.NTSB NYC02LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Ashland, METhe pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB IAD01LA104Accident · No injuriesLimited investigationFinal reportCessna 172P · Augusta, METhe pilot's failure to maintain the proper distance from a sign post during taxi.NTSB IAD01LA105Accident · No injuriesLimited investigationFinal reportBeech 19 · Augusta, METhe student pilot's improper flare, which resulted in a hard landing.NTSB NYC01FA201Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Sedgwick, METhe failure of the pilot to maintain control while maneuvering.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 NYC01LA183Accident · No injuriesLimited investigationFinal reportBeech BE-36 · Biddeford, METhe pilot's inadequate preflight inspection, which resulted in an attempted takeoff with a control column lock installed.NTSB NYC01LA149Accident · No injuriesLimited investigationFinal reportCessna 150 · Lincoln, MEA loss of engine power for an undetermined reason.NTSB IAD01LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Ashland, MEloss of partial engine power due to carburetor icing.NTSB NYC01LA119Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Monson, METhe pilot's inadequate aircraft preflight inspection, which resulted in a total loss of engine power during climb due to fuel contamination.NTSB NYC01LA118Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Brewer, METhe pilot's inadequate preflight preparation, which resulted in insufficient fuel in the forward tank and loss of engine power during the climb. Also causal, was the pilot's failure to maintain airspeed after the engine failure, which resulted in an…NTSB IAD01LA030Accident · No injuriesLimited investigationFinal reportCessna 120 · Trenton, METhe pilot's improper touchdown in the snow after the airplane became prematurely airborne during an attempted takeoff. A factor was the pilot's inadequate training.