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 NYC70D0066Accident · No injuriesClosedPiper PA-23 · Wolfeboro, NHJul 14, 1969 · N4486P · Substantial damage NTSB NYC70D0017Accident · No injuriesClosedStinson 108 · Wolfeboro, NHJun 18, 1969 · N97699 · Substantial damage NTSB NYC69D0438Accident · Minor injuriesClosedCessna 150 · Pittsburgh, NHMay 7, 1969 · CF-WIU · Destroyed NTSB NYC69F0413Accident · No injuriesClosedPiper PA-28 · Laconia, NHMay 4, 1969 · N9685J · Substantial damage NTSB NYC69D0433Accident · No injuriesClosedPiper J-3 · Nashua, NHMay 3, 1969 · N88597 · Substantial damage NTSB NYC69D0405Accident · No injuriesClosedBeech A-23 · Manchester, NHApr 28, 1969 · N7984L · Substantial damage NTSB NYC69F0414Accident · No injuriesClosedCessna 195 · Keene, NHApr 25, 1969 · N1063D · Substantial damage NTSB NYC70D0060Accident · No injuriesClosedCessna 150 · Rochester, NHApr 4, 1969 · N7157X · Substantial damage NTSB NYC69F0369Accident · Minor injuriesClosedAero Comdr 520 · Claremont, NHMar 13, 1969 · N4164B · Substantial damage NTSB NYC69D0360Accident · No injuriesClosedCessna 150 · Nashua, NHMar 1, 1969 · N6801F · Substantial damage NTSB NYC69D0321Accident · No injuriesClosedCessna 172 · Rochester, NHFeb 1, 1969 · N9712T · Substantial damage NTSB NYC69A0077Accident · 1 fatalClosedPiper PA-23 · Windham, NHFeb 1, 1969 · N777M · Destroyed NTSB NYC69D0313Accident · No injuriesClosedPiper PA-28 · Laconia, NHJan 27, 1969 · N6148W · Substantial damage NTSB NYC69D0298Accident · No injuriesClosedPiper PA-28 · North Conway, NHJan 5, 1969 · N9641J · Substantial damage NTSB NYC69F0281Accident · No injuriesClosedCessna 182F · Rochester, NHDec 18, 1968 · N3311U · Substantial damage NTSB NYC69D0267Accident · No injuriesClosedAeronca 7DC · Rye, NHNov 24, 1968 · N1113 · Substantial damage NTSB DCA69A0004Accident · 32 fatalClosedFairchild FH227C · Hanover, NHOct 25, 1968 · N380NE · Destroyed NTSB NYC69D0217Accident · No injuriesClosedBeech A23 · Rochester, NHOct 9, 1968 · N1493L · Substantial damage NTSB NYC69F0198Accident · Minor injuriesClosedCessna 150 · Seabrook, NHSep 22, 1968 · N5781E · Substantial damage NTSB NYC69I0029Incident · No injuriesClosedFairchild FH-227 · Manchester, NHSep 7, 1968 · N375NE · Minor damage NTSB NYC69D0196Accident · No injuriesClosedPiper PA-30 · Twin Mountain, NHSep 1, 1968 · N7816Y · Substantial damage NTSB NYC69A0025Accident · 3 fatalClosedCessna 180D · Ashland, NHAug 29, 1968 · N3170D · Destroyed NTSB NYC69F0144Accident · 1 fatalClosedCessna 150E · Freedom, NHAug 17, 1968 · N631MA · Destroyed NTSB NYC69F0114Accident · 1 fatalClosedPiper PA-18A · Derry, NHAug 16, 1968 · N1866A · Destroyed NTSB NYC69F0109Accident · No injuriesClosedPiper PA-28 · Laconia, NHJul 31, 1968 · N9901W · Substantial damage NTSB NYC69D0113Accident · No injuriesClosedCessna 177 · Hampton, NHJul 28, 1968 · N2293Y · Substantial damage NTSB NYC69D0098Accident · Minor injuriesClosedPiper PA-28 · Plymouth, NHJul 20, 1968 · N4567R · Substantial damage NTSB NYC69D0066Accident · Serious injuriesClosedErco 415-C · Belmont, NHJul 2, 1968 · N94683 · Substantial damage NTSB NYC69D0009Accident · Serious injuriesClosedCessna 170 · Salem, NHJun 7, 1968 · N2519V · Destroyed NTSB NYC68F0456Accident · No injuriesClosedMooney M20E · Salem, NHApr 13, 1968 · N2555W · Substantial damage NTSB NYC68D0441Accident · Minor injuriesClosedPiper PA-18 · Tuftonboro, NHApr 12, 1968 · N285HC · Substantial damage NTSB NYC68F0444Accident · Minor injuriesClosedCessna 172 · Salem, NHApr 7, 1968 · N6048A · Substantial damage NTSB NYC68D0380Accident · No injuriesClosedCessna 182 · Keene, NHFeb 16, 1968 · N3129Q · Substantial damage NTSB NYC68A0099Accident · 2 fatalClosedCessna 172H · New Boston, NHFeb 14, 1968 · N3730F · Destroyed NTSB NYC68F0360Accident · No injuriesClosedCessna 172 · Rochester, NHJan 27, 1968 · N9712T · Substantial damage NTSB NYC68D0347Accident · No injuriesClosedCessna 310D · Lebanon, NHDec 22, 1967 · N818V · Substantial damage NTSB NYC68A0074Accident · 1 fatalClosedCessna 401 · Whitefield, NHNov 26, 1967 · N3280Q · Destroyed NTSB NYC68F0290Accident · No injuriesClosedBeech S35 · Nashua, NHNov 3, 1967 · N5876J · Substantial damage NTSB NYC68D0250Accident · No injuriesClosedPiper PA-28 · Hampton, NHOct 20, 1967 · N7361W · Substantial damage NTSB NYC68F0228Accident · No injuriesClosedCessna 185 · Nashua, NHOct 9, 1967 · N9977X · Substantial damage NTSB NYC68A0036Accident · 1 fatalClosedMaule M4 · Marlborough, NHAug 31, 1967 · N9869M · Destroyed NTSB NYC68A0030Accident · 1 fatalClosedBell 47G-5 · Kingston, NHAug 22, 1967 · N8592F · Destroyed NTSB NYC68D0169Accident · No injuriesClosedCessna 305A · Salem, NHAug 13, 1967 · N1836 · 2 aircraft · Substantial damage NTSB NYC68A0024Accident · 5 fatalClosedPiper PA-28 · Laconia, NHAug 6, 1967 · N4226J · 2 aircraft · Destroyed NTSB NYC68A0020Accident · No injuriesClosedBensen B-8-M · Acworth, NHJul 27, 1967 · N10030 · Substantial damage NTSB NYC68D0078Accident · No injuriesClosedCessna 170B · Milan, NHJul 23, 1967 · N1645D · Substantial damage NTSB NYC68D0087Accident · No injuriesClosedPiper PA-23 · Laconia, NHJul 7, 1967 · N5670Y · Substantial damage NTSB NYC68D0034Accident · No injuriesClosedCessna 150 · Nashua, NHJul 3, 1967 · N4156V · Substantial damage NTSB NYC68D0076Accident · No injuriesClosedCessna 182 · Wolfeboro, NHJul 2, 1967 · N2797Q · Substantial damage NTSB NYC68D0025Accident · No injuriesClosedPiper J3C · Amherst, NHJun 26, 1967 · N88597 · Substantial damage