Skip to content

NTSB investigations, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 c."eventStateOrRegion" = 'NH' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 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 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 NYC78DNC19Accident · Minor injuriesClosedPiper J-3 · Croydon, NHMar 10, 1978 · N35054 · Substantial damage NTSB NYC78DNC18Accident · No injuriesClosedCessna 150 · Colebrook, NHFeb 28, 1978 · N6482G · Substantial damage NTSB NYC78FA018Accident · 3 fatalClosedCessna 180 · Berlin, NHDec 28, 1977 · N456LM · Substantial damage NTSB NYC78DNC07Accident · No injuriesClosedCessna 140 · Jaffey, NHDec 24, 1977 · N90019 · Substantial damage NTSB NYC78DNC06Accident · Minor injuriesClosedCessna 177 · Jaffrey, NHDec 23, 1977 · N29319 · Substantial damage NTSB NYC78DNC05Accident · No injuriesClosedCessna 172M · Nashua, NHDec 23, 1977 · N13599 · Substantial damage NTSB NYC78DNC02Accident · No injuriesClosedChampion 7GCBC · South Swanzey, NHOct 19, 1977 · N9095L · Substantial damage NTSB NYC78DNC03Accident · No injuriesClosedPiper PA-28 · Chickville, NHOct 16, 1977 · N38155 · Substantial damage NTSB NYC77DNC54Accident · No injuriesClosedCessna 172 · Lancaster, NHSep 5, 1977 · N1721F · Substantial damage NTSB NYC77FNC50Accident · No injuriesClosedCessna 177RG · Manchester, NHAug 26, 1977 · N177RG · Substantial damage NTSB NYC77DNC48Accident · No injuriesClosedEnstrom F-28C · Manchester, NHAug 19, 1977 · N642H · Substantial damage NTSB NYC77DNC40Accident · No injuriesClosedCessna 150 · Laconia, NHJul 10, 1977 · N66309 · Substantial damage NTSB NYC77FNC38Accident · Serious injuriesClosedPitts S1C · Nashua, NHJun 20, 1977 · N101PJ · Substantial damage NTSB NYC77DNC35Accident · No injuriesClosedCessna 170B · Tilton, NHJun 5, 1977 · N2238D · Substantial damage NTSB NYC77DNC34Accident · Minor injuriesClosedCessna 182 · Exeter, NHMay 30, 1977 · N6436A · Substantial damage NTSB NYC77DNC32Accident · No injuriesClosedSchweizer SGS233 · Salem, NHMay 15, 1977 · N2533H · Substantial damage NTSB NYC77DNC29Accident · No injuriesClosedBellanca 8GCBC · Cntr Strafford, NHMay 6, 1977 · N88183 · Substantial damage NTSB NYC77DNC25Accident · No injuriesClosedCessna 140 · Center Ossipee, NHApr 17, 1977 · CF-VIW · Substantial damage NTSB NYC77FA052Accident · 1 fatalClosedPiper PA-28 · Nashua, NHApr 15, 1977 · N75042 · Substantial damage NTSB NYC77DNC22Accident · No injuriesClosedGrum Amer AA5 · Rochester, NHMar 9, 1977 · N6050L · Substantial damage NTSB NYC77FA035Accident · 3 fatalClosedBeech V35B · Nashua, NHMar 4, 1977 · N974DP · Destroyed NTSB NYC77DNC19Accident · Minor injuriesClosedStinson 108-1 · Salem, NHJan 23, 1977 · N8874K · Substantial damage NTSB NYC77DNC16Accident · No injuriesClosedBeech 35 · Manchester, NHJan 12, 1977 · N9392Y · Substantial damage NTSB NYC77FNC14Accident · No injuriesClosedCessna 310J · New London, NHDec 27, 1976 · N3196L · Substantial damage NTSB NYC77DNC10Accident · Minor injuriesClosedCessna 150 · Hampton, NHNov 13, 1976 · N45160 · Substantial damage NTSB NYC77FNC04Accident · Serious injuriesClosedSchleicher AS-K14 · North Conway, NHOct 22, 1976 · N11RT · Substantial damage NTSB NYC77FNC02Accident · Serious injuriesClosedPiper PA-28 · Portsmouth, NHOct 16, 1976 · N41738 · Substantial damage NTSB NYC76DNC63Accident · Serious injuriesClosedLake LA-4 · Derry, NHAug 6, 1976 · N1148L · Substantial damage NTSB NYC76FNC61Accident · Minor injuriesClosedCessna A185E · Wolfeboro, NHAug 4, 1976 · N185HC · Substantial damage NTSB NYC76FNC52Accident · Serious injuriesClosedPiper PA-28 · Keene, NHJun 3, 1976 · N95228 · Destroyed NTSB NYC76FNC47Accident · No injuriesClosedCessna 401 · Tilton, NHApr 21, 1976 · N18PS · Substantial damage NTSB NYC76DNC35Accident · No injuriesClosedCessna 206 · N Wolfeboro, NHFeb 27, 1976 · N8689Z · Substantial damage NTSB NYC76DNC34Accident · No injuriesClosedCessna 150 · Nashua, NHDec 29, 1975 · N66586 · Substantial damage NTSB NYC76DNC27Accident · Minor injuriesClosedSchweizer SGS134 · Glen, NHOct 22, 1975 · CF-QPT · Substantial damage NTSB NYC76FNC24Accident · Minor injuriesClosedMooney M20E · Jaffrey, NHOct 5, 1975 · N9055V · Substantial damage NTSB NYC76DNC19Accident · No injuriesClosedLuscombe 8E · Bristol, NHSep 10, 1975 · N2399K · Minor damage NTSB NYC76FNC18Accident · Serious injuriesClosedCessna 172G · Waterville Vly, NHSep 8, 1975 · N1318F · Destroyed NTSB NYC76DNC15Accident · Serious injuriesClosedCessna 150F · Center Ossipee, NHSep 1, 1975 · N8411G · Substantial damage NTSB NYC76DNC14Accident · Minor injuriesClosedCessna 150 · Claremont, NHAug 31, 1975 · N63073 · Destroyed NTSB NYC76DNC12Accident · No injuriesClosedCessna 150 · Rye Harbor, NHAug 20, 1975 · N6106G · Destroyed NTSB NYC76DNC10Accident · No injuriesClosedBeech B19 · Manchester, NHAug 14, 1975 · N1964W · Substantial damage NTSB NYC76DNC06Accident · No injuriesClosedBellanca 7GCBC · Jaffrey, NHAug 3, 1975 · N9125L · Substantial damage NTSB NYC76DNC07Accident · No injuriesClosedSchweizer 126D · Franconia, NHAug 2, 1975 · N34431 · Substantial damage NTSB NYC76DNC02Accident · No injuriesClosedPiper PA-28 · Errol, NHJul 22, 1975 · N7297J · Substantial damage NTSB NYC75DNC39Accident · No injuriesClosedPiper PA-28 · Keene, NHJun 25, 1975 · N7227F · Substantial damage NTSB NYC75DNC29Accident · No injuriesClosedCessna 175 · Milan, NHApr 13, 1975 · N7255M · Substantial damage NTSB NYC75AN090Accident · 2 fatalClosedCessna 150F · Mason, NHMar 12, 1975 · N8273S · Destroyed NTSB NYC75FNC25Accident · No injuriesClosedBeech 23 · Manchester, NHMar 9, 1975 · N8722M · Substantial damage NTSB NYC75AN085Accident · 1 fatalClosedPiper PA-28 · Rummey, NHFeb 8, 1975 · N8827N · Substantial damage NTSB NYC75FNC22Accident · Minor injuriesClosedCessna 182A · Berlin, NHJan 5, 1975 · N2202G · Substantial damage