NTSB investigations, 1994, NH
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
| 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\") = 1994
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") = 1994 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 NYC95DNC01Accident · No injuriesFinal reportWyman Scorpion II · Cornish Flat, NHPartial failure and subsequent partial separation of skin on the underside of one main rotor blade, which resulted in a severe vibration, in-flight loss of aircraft control, and impact with the ground during an attempted autorotation.NTSB NYC95LA026Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Nashua, NHThe pilot's improper touchdown which resulted in a rollover.NTSB NYC95LA028Accident · No injuriesLimited investigationFinal reportRans/Hine S-10 · Hampton, NHa seized piston in the foward cylinder due to a lean mixture.NTSB NYC95LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Center Harbor, NHThe pilot's inadequate compensation for a crosswind condition.NTSB NYC95LA004Accident · No injuriesLimited investigationFinal reportCessna 182N · New London, NHthe failure of the number four push rod, which resulted in the complete loss of engine power and forced landing, and the subsequent nose over on soft terrain.NTSB BFO94LA156Accident · No injuriesLimited investigationFinal reportCessna 195B · Ossipee, NHSeparation of the left main landing gear due to fatigue failure.NTSB BFO94LA153Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Wolfeboro, NHThe pilot's failure to maintain directional control during landing which resulted in inflight collission with trees.NTSB BFO94LA146Accident · Serious injuriesLimited investigationFinal reportAdvanced Acft Waco 10 GXE · Rochester, NHthe partial loss of engine power for undetermined reasons. Related factors were unsuitable terrain (trees) and the inadvertent stall.NTSB BFO94LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Wolfeboro, NHThe pilot's inadequate inflight decision, which resulted in a downwnind landing and overrun of the runway.NTSB NYC94LA155Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4A · Cannan, NHThe pilot's failure to maintain airspeed which resulted in an inadvertent stall and inflight collision with terrain. Factors were a loss of lift and the pilot's in-flight decision to maneuver too close to the ridge.NTSB NYC94LA108Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bristol, NHthe failure of maintenance personnel to remove an object from the carburetor heat duct during annual inspection which blocked induction air and resulted in the loss of engine power, and the subsequent collision with the terrain during a forced landing.NTSB BFO94LA081Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Hollis, NHThe pilot's inadequate preflight inspection which failed to detect contaminated fuel which resulted in fuel starvation.NTSB NYC94LA073Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G109B · Nashua, NHThe certified flight instructor's delay in taking remedial action, which resulted in the motor-glider colliding with trees.