NTSB investigations, 1997, NH
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
| 1964 | 14 |
|---|---|
| 1965 | 20 |
| 1966 | 18 |
| 1967 | 26 |
| 1968 | 21 |
| 1969 | 18 |
| 1970 | 7 |
| 1971 | 18 |
| 1972 | 27 |
| 1973 | 27 |
| 1974 | 17 |
| 1975 | 18 |
| 1976 | 9 |
| 1977 | 21 |
| 1978 | 20 |
| 1979 | 14 |
| 1980 | 20 |
| 1981 | 5 |
| 1982 | 18 |
| 1983 | 19 |
| 1984 | 16 |
| 1985 | 12 |
| 1986 | 18 |
| 1987 | 18 |
| 1988 | 16 |
| 1989 | 6 |
| 1990 | 9 |
| 1991 | 15 |
| 1992 | 9 |
| 1993 | 13 |
| 1994 | 13 |
| 1995 | 6 |
| 1996 | 11 |
| 1997 | 9 |
| 1998 | 7 |
| 1999 | 6 |
| 2000 | 11 |
| 2001 | 11 |
| 2002 | 3 |
| 2003 | 4 |
| 2004 | 8 |
| 2005 | 12 |
| 2006 | 5 |
| 2007 | 9 |
| 2008 | 6 |
| 2009 | 4 |
| 2010 | 4 |
| 2011 | 5 |
| 2012 | 4 |
| 2013 | 6 |
| 2014 | 6 |
| 2015 | 6 |
| 2016 | 13 |
| 2017 | 5 |
| 2018 | 4 |
| 2019 | 4 |
| 2020 | 6 |
| 2021 | 5 |
| 2022 | 5 |
| 2023 | 6 |
| 2024 | 7 |
| 2025 | 7 |
| 2026 | 6 |
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\") = 1997
AND c.\"eventStateOrRegion\" = 'NH' 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") = 1997 AND c."eventStateOrRegion" = 'NH' 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 NYC97LA163Accident · 1 fatalLimited investigationFinal reportElliot Monnett Moni · Hollis, NHThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall spin and collision with terrain.NTSB NYC97LA152Accident · Serious injuriesLimited investigationFinal reportKenneson Merlin GT · Kensington, NHthe pilot's inability to obtain and/or maintain control of the airplane after takeoff.NTSB IAD97LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Hampton, NHThe pilot's poor judgement for intentionally shutting down an engine to perform a practice single engine landing, which led to a single engine go-around due to conflicting traffic.NTSB IAD97LA091Accident · No injuriesLimited investigationFinal reportAeronca S15AC · Laconia, NHThe pilot's inadequate compensation for a crosswind, which resulted in the loss of aircraft control. A factor in the accident was the gusting winds.NTSB IAD97LA077Accident · No injuriesLimited investigationFinal reportCessna 182P · Wentworth, NHPilot's inadequate preflight planning to determine the suitability of an unimproved field for landing.NTSB IAD97LA075Accident · No injuriesLimited investigationFinal reportCessna 180J · Lebanon, NHThe loss of engine power for undetermined reasons.NTSB NYC97LA070Accident · No injuriesLimited investigationFinal reportCessna 150E · Wolfeboro, NHThe pilot's improper preflight, and failure to refuel the airplane, which resulted in fuel exhaustion during the initial climb after takeoff, and the subsequent forced landing and collision with a mound of dirt.NTSB NYC97LA044Accident · Serious injuriesLimited investigationFinal reportMooney 20F · Jaffrey, NHThe pilot's failure to maintain aircraft control during a go around attempt, which resulted in a loss of control and collision with trees.NTSB IAD97FA043Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Alton, NHAn exhaust gas leak, due to inadequate maintenance, which resulted in carbon monoxide poisoning, and incapacitation of the pilot.