NTSB investigations, 1998, ME
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 1998
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") = 1998 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 NYC98LA176Accident · No injuriesLimited investigationFinal reportCessna 182Q · Bingham, METhe pilot's inattention to changing wind conditions, and lack of correction for the change. A factor in the accident was the damp grass runway.NTSB IAD98LA083Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Newburg, METhe pilot's failure to maintain directional control. Related factors were the long, wet, unmowed grass runway.NTSB NYC98LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Rockland, METhe pilot's failure to attain adequate airspeed during the takeoff, which resulted in a stall.NTSB IAD98LA080Accident · No injuriesLimited investigationFinal reportAeronca 7FC · Somesville, METhe pilot's inadequate planning and decision, which fail to consider the effect of takeoff in the direction of the sunlight, which resulted in the pilot encountering sunglare and the loss of aircraft control.NTSB IAD98LA078Accident · Serious injuriesLimited investigationFinal reportMastopietro Rans S12 · Phillips, MELoss of engine power due to a separated oil line. A related factor was the unsuitable field.NTSB NYC98LA135Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-65 · West Buxton, MEfailure of the pilot to see-and-avoid power lines (inadequate visual lookout), as he was approaching to make a water landing on a river.NTSB NYC98FA092Accident · 1 fatalField investigationFinal reportAerostar 600A · Mapleton, MEthe failure of the pilot to maintain control of the airplane during takeoff for undetermined reasons.NTSB NYC98FA071Accident · 2 fatalField investigationFinal reportPiper PA-31-310 · Presque Isle, METhe pilot's failure to follow the published instrument approach procedure and his descent below the minimum descent altitude. Contributing factors were the night conditions, low ceilings, and fog.NTSB NYC98LA070Accident · No injuriesLimited investigationFinal reportCessna 320F · Lincoln, METhe pilot's failure to maintain adequate altitude which resulted in left main landing gear contacting a snowbank during the landing approach.NTSB IAD98LA019Accident · No injuriesLimited investigationFinal reportCessna 172P · Augusta, METhe inadequate lookout of the pilot in command.