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 NYC81FNC03Accident · No injuriesClosedBellanca 8GCBC · Manchester, NHOct 12, 1980 · N50402 · Substantial damage NTSB NYC80FA092Accident · Serious injuriesClosedBeech D-55 · Keene, NHSep 25, 1980 · N7664N · Destroyed NTSB NYC80DNC46Accident · No injuriesClosedGrum-Amer AA-5 · Manchester, NHSep 19, 1980 · N1337R · Substantial damage NTSB NYC80FNC45Accident · Minor injuriesClosedStinson 108-2 · Windham, NHSep 5, 1980 · N9716K · Substantial damage NTSB NYC80DA078Accident · No injuriesClosedBeech A23-24 · Wolfeboro, NHAug 28, 1980 · N247DK · Destroyed NTSB NYC80DNC39Accident · Minor injuriesClosedCessna 180 · New London, NHAug 24, 1980 · N2520K · Substantial damage NTSB NYC80FNC36Accident · Minor injuriesClosedBeech A36 · Laconia, NHAug 16, 1980 · N36ZX · Substantial damage NTSB NYC80FNC27Accident · No injuriesClosedCessna 210 · Wolfebore, NHJun 13, 1980 · N510PE · Substantial damage NTSB NYC80FNC26Accident · No injuriesClosedPiper PA-28 · Antrim, NHJun 11, 1980 · N55817 · Substantial damage NTSB NYC80DNC25Accident · Minor injuriesClosedPiper J5A · Newport, NHMay 17, 1980 · N35758 · Substantial damage NTSB NYC80FNC23Accident · No injuriesClosedMooney M20C · Keene, NHMay 10, 1980 · N28R · Substantial damage NTSB NYC80FA038Accident · 3 fatalClosedCessna 177RG · Peterborough, NHMay 1, 1980 · N8030G · Destroyed NTSB NYC80FNC22Accident · Serious injuriesClosedLake 4-200 · Laconia, NHApr 22, 1980 · N1063L · Substantial damage NTSB NYC80DNC21Accident · No injuriesClosedEnstrom 280C · Jackson, NHApr 20, 1980 · N51791 · Substantial damage NTSB NYC80FNC20Accident · Minor injuriesClosedGrum-Amer AA1-B · Moultonboro, NHApr 19, 1980 · N1630R · Substantial damage NTSB NYC80FNC14Accident · Serious injuriesClosedCessna 170 · Dublin, NHFeb 26, 1980 · N4006V · Substantial damage NTSB NYC80FNC12Accident · No injuriesClosedBeech C50 · Manchester, NHFeb 22, 1980 · N4900B · Substantial damage NTSB NYC80FNC10Accident · No injuriesClosedCessna 152 · Keene, NHJan 31, 1980 · N5282B · Substantial damage NTSB NYC79FA101Accident · 2 fatalClosedBeech 19 · Manchester, NHSep 16, 1979 · N24601 · Destroyed NTSB NYC79FA094Accident · Minor injuriesClosedBell 206B · Merrimack, NHSep 11, 1979 · N90022 · Substantial damage NTSB NYC79FA093Accident · No injuriesClosedCessna 172 · Keene, NHSep 9, 1979 · N20613 · Substantial damage NTSB NYC79FA091Accident · 3 fatalClosedPiper PA-28 · Charlestown, NHSep 9, 1979 · N159TA · Destroyed NTSB NYC79FNC36Accident · No injuriesClosedWaco UPF-7 · North Conway, NHJul 10, 1979 · N32127 · Substantial damage NTSB NYC79DNC32Accident · Minor injuriesClosedLake LA-4 · Wolfeboro, NHJun 27, 1979 · N2832P · Destroyed NTSB NYC79FA048Accident · 1 fatalClosedCessna 150H · Dalton, NHJun 3, 1979 · N7052S · Destroyed NTSB NYC79FNC28Accident · No injuriesClosedCessna 150 · Mt Vernon, NHMay 11, 1979 · N19435 · Substantial damage NTSB NYC79FNC26Accident · No injuriesClosedLake 4-200 · Whitefield, NHMay 6, 1979 · N6181V · Substantial damage NTSB NYC79FA042Accident · 1 fatalClosedPiper PA-18 · Lebanon, NHApr 21, 1979 · N2344J · Destroyed NTSB NYC79FNC23Accident · No injuriesClosedPiper PA-32R · New London, NHApr 17, 1979 · N1982H · Substantial damage NTSB NYC79DNC18Accident · No injuriesClosedPiper PA-28 · Antrim, NHFeb 16, 1979 · N8262 · Substantial damage NTSB NYC79FNC16Accident · No injuriesClosedPiper PA-31 · Laconia, NHJan 31, 1979 · N2ZM · Substantial damage NTSB NYC79FA020Accident · Minor injuriesClosedLockheed L-1329 · Concord, NHJan 22, 1979 · N5541L · Substantial damage NTSB NYC79FNC15Accident · Serious injuriesClosedCessna 172N · Lebanon, NHDec 28, 1978 · N738LK · Substantial damage NTSB NYC79FNC11Accident · No injuriesClosedCessna 172N · Hampton, NHDec 5, 1978 · N5172E · Substantial damage NTSB NYC79FNC09Accident · 1 fatalClosedDehavilland DH-82A · No.Hampton, NHNov 5, 1978 · N90406 · Substantial damage NTSB NYC79DNC07Accident · No injuriesClosedAeronca 7AC · N.Hampton, NHOct 22, 1978 · N3613E · Substantial damage NTSB NYC79DNC06Accident · No injuriesClosedCessna 305A · Rochester, NHOct 22, 1978 · N5306G · Substantial damage NTSB NYC78FNC05Accident · No injuriesClosedCessna 172N · Brookline, NHOct 20, 1978 · N737MP · Substantial damage NTSB NYC79DNC04Accident · No injuriesClosedBirdman TL-1A · Hudson, NHOct 8, 1978 · N2286K · Substantial damage NTSB NYC78FA085Accident · 2 fatalClosedMitsubishi MU-2P · Bedford, NHAug 28, 1978 · N765MA · Destroyed NTSB NYC78FNC42Accident · Minor injuriesClosedCessna 182D · Hollis, NHJul 29, 1978 · N8810X · Substantial damage NTSB NYC78FNC41Accident · Minor injuriesClosedLake 4-200 · Meredith, NHJul 23, 1978 · N1049L · Destroyed NTSB NYC78DNC39Accident · No injuriesClosedMolina PIK-20 · Pelham, NHJul 12, 1978 · N20WW · Substantial damage NTSB NYC78FNC36Accident · Serious injuriesClosedCessna 172 · Wolfeboro, NHJul 1, 1978 · N3741S · Destroyed NTSB NYC78FA066Accident · 1 fatalClosedGrum Amer AA1-C · Tamsworth, NHJun 25, 1978 · N9544U · Destroyed NTSB NYC78FNC31Accident · Serious injuriesClosedPiper PA-28 · Jaffrey, NHJun 17, 1978 · N7279F · Substantial damage NTSB NYC78FNC27Accident · Minor injuriesClosedWaco UPF-7 · North Conway, NHMay 22, 1978 · N39713 · Substantial damage NTSB NYC78FNC26Accident · No injuriesClosedPiper PA-24 · Barnstead, NHMay 14, 1978 · N6465P · Substantial damage NTSB NYC78FNC24Accident · No injuriesClosedStinson 10A · Ossipee, NHMay 13, 1978 · N32226 · Substantial damage NTSB NYC78DNC22Accident · No injuriesClosedPiper PA-28 · Antrim, NHApr 12, 1978 · N8262N · Substantial damage