NTSB investigations, 2000, NH
180,598 investigations by the National Transportation Safety Board since 1962: 174,578 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\") = 2000
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") = 2000 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 NYC01FA056Accident · 1 fatalField investigationFinal reportCessna 310Q · Chesterfield, NHThe pilot's continued flight into icing conditions, and his failure to use alternate air. A factor was the icing conditions.NTSB NYC01LA043Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Londonderry, NHThe pilot's failure to obtain the proper touchdown point.NTSB NYC00LA255Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Laconia, NHThe pilot's failure to maintain aircraft control. A factor in the accident was the large wave.NTSB NYC00LA244Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Windsor, NHthe pilot's improper preflight planning to make a takeoff toward obstacles, and his delayed decision to abort the takeoff, which resulted in an overrun into unsuitable terrain.NTSB NYC00LA186Accident · No injuriesLimited investigationFinal reportHelfer Flightstar II · Greenland, NHThe pilot-in-command's improper decision to takeoff uphill, on a short runway with 50-foot high utility wires at the end, at a high gross weight. Factors were the high weight and uphill terrain.NTSB NYC00LA173Accident · No injuriesLimited investigationFinal reportFleet 16B · Rochester, NHThe pilot's failure to maintain directional control. A factor in the accident was the pilot's lack of experience in the accident airplane make and model.NTSB NYC00LA170Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · Nashua, NHThe flight instructor's delayed corrective action.NTSB NYC00LA113Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Lanconia, NHThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall.NTSB NYC00LA105Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Keene, NHThe CFI's failure to perform remedial action in a timely manner which resulted in a hard landing during the practice autorotation. A factor in this accident was the CFI's lack of total experience as a flight instructor.NTSB NYC00LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Center Harbor, NHThe pilot-in-command attempted a low pass and misjudged his altitude.NTSB NYC00LA072Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Alton Bay, NHThe pilot's failure to maintain control of the airplane during takeoff which resulted in an inadvertent stall. A factor in the accident was the pilot's inadequate compensation for the wind conditions.