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 NYC73DNC10Accident · No injuriesClosedPiper PA-28 · Melvin Village, NHJul 30, 1972 · N3580K · Substantial damage NTSB NYC73DNC08Accident · No injuriesClosedPiper PA-23 · Wolfboro, NHJul 28, 1972 · N5813Y · Substantial damage NTSB NYC73FNC15Accident · No injuriesClosedPiper PA-30 · Manchester, NHJul 27, 1972 · N7846Y · Substantial damage NTSB NYC73FNC16Accident · No injuriesClosedCessna 150G · Manchester, NHJul 24, 1972 · N5802G · Substantial damage NTSB NYC73DNC04Accident · Serious injuriesClosedAeronca 7BCM · Dublin, NHJul 9, 1972 · N3944A · Substantial damage NTSB NYC73DNC01Accident · No injuriesClosedSchweizer 1-26 · Dover, NHJul 2, 1972 · N679U · Substantial damage NTSB NYC72FNC45Accident · No injuriesClosedDehavilland DHC-2 · W.Lebanon, NHJun 27, 1972 · N5160G · Substantial damage NTSB NYC72AN158Accident · 2 fatalClosedPiper PA-28R · Gilford, NHJun 18, 1972 · N5291T · Destroyed NTSB NYC72DNC44Accident · No injuriesClosedCessna 182 · Brookline, NHJun 7, 1972 · N71618 · Substantial damage NTSB NYC72DNC51Accident · Serious injuriesClosedCessna 140 · Rochester, NHMay 27, 1972 · N1980N · Destroyed NTSB NYC72DNC50Accident · No injuriesClosedPiper PA-28 · Keene, NHMay 22, 1972 · N6447R · Substantial damage NTSB NYC72FNC46Accident · Minor injuriesClosedCessna 150 · Farmington, NHMay 21, 1972 · N3509L · Destroyed NTSB NYC72DNC48Accident · No injuriesClosedNavion L-17B · Manchester, NHMay 7, 1972 · N5042K · Substantial damage NTSB NYC72AN135Accident · 3 fatalClosedBeech P35 · Kingston, NHApr 26, 1972 · N8900M · Substantial damage NTSB NYC72FNC34Accident · No injuriesClosedCessna 175B · Rochester, NHApr 21, 1972 · N8243T · Substantial damage NTSB NYC72DNC35Accident · Minor injuriesClosedPiper PA-28 · Lebanon, NHApr 2, 1972 · N2688 · Destroyed NTSB NYC72FNC28Accident · Minor injuriesClosedPiper PA-32 · Nashua, NHFeb 23, 1972 · N3768W · Substantial damage NTSB NYC72DNC24Accident · Minor injuriesClosedPiper PA-28 · Londonderry, NHFeb 2, 1972 · N9337W · Substantial damage NTSB NYC72DNC27Accident · No injuriesClosedSchweizer 2-33 · Salem, NHJan 30, 1972 · N1236S · Substantial damage NTSB NYC72DNC23Accident · No injuriesClosedPiper PA-23 · Groveton, NHJan 19, 1972 · N874DN · Substantial damage NTSB NYC72DNC22Accident · No injuriesClosedLuscombe 8A · Laconia, NHJan 12, 1972 · N25288 · Substantial damage NTSB NYC72DNC18Accident · No injuriesClosedCessna 150F · Plymouth, NHDec 12, 1971 · N8683G · Substantial damage NTSB NYC72FNC20Accident · No injuriesClosedCessna 150 · Claremont, NHDec 5, 1971 · N6270G · Substantial damage NTSB NYC72AN067Accident · 1 fatalClosedBay Avn. Superv · Keene, NHNov 16, 1971 · N430MD · Destroyed NTSB NYC72FNC13Accident · No injuriesClosedCessna 182 · Penacook, NHOct 27, 1971 · N8480S · Substantial damage NTSB NYC72DNC11Accident · No injuriesClosedCessna 150 · Derry, NHOct 16, 1971 · N7118X · Substantial damage NTSB NYC72AN056Accident · 1 fatalClosedCessna 150 · Henniker, NHOct 15, 1971 · N6749G · Destroyed NTSB NYC72DNC15Accident · Minor injuriesClosedLuscombe 8A · Auburn, NHOct 8, 1971 · N77877 · Substantial damage NTSB NYC72AN044Accident · 1 fatalClosedPiper PA-23 · Lyme Center, NHSep 20, 1971 · N3435P · Destroyed NTSB NYC72DNC07Accident · Minor injuriesClosedBellanca 14-19 · Bristol, NHAug 6, 1971 · N8834R · Substantial damage NTSB NYC72FNC05Accident · No injuriesClosedCessna 170B · Brookline, NHJul 27, 1971 · N4586C · Substantial damage NTSB NYC72FNC01Accident · Minor injuriesClosedMooney M20 · Allenstown, NHJul 3, 1971 · N9715M · Substantial damage NTSB NYC72AN003Accident · 1 fatalClosedPiper PA-28R · Madison, NHJul 3, 1971 · N2965R · Destroyed NTSB NYC71AN106Accident · 4 fatalClosedBeech C35 · Manchester, NHApr 22, 1971 · N144H · Destroyed NTSB NYC71FNC25Accident · No injuriesClosedAero Comdr 100 · North Havrhill, NHApr 11, 1971 · N3864X · Substantial damage NTSB NYC71AN095Accident · 2 fatalClosedPiper PA-23 · Gorham, NHMar 21, 1971 · N4841P · Destroyed NTSB NYC71DFG16Accident · No injuriesClosedPiper PA-28 · Laconia, NHMar 17, 1971 · N9394J · Substantial damage NTSB NYC71DFG10Accident · No injuriesClosedCessna 140 · Pelham, NHJan 27, 1971 · N2434N · Substantial damage NTSB NYC71DFG14Accident · No injuriesClosedPiper PA-24 · Twin Mountain, NHJan 17, 1971 · N5570P · Substantial damage NTSB NYC71DFG08Accident · Minor injuriesClosedCessna 185A · Nashua, NHNov 12, 1970 · N4130Y · Substantial damage NTSB NYC71AN049Accident · 1 fatalClosedSchweizer SGS1 · Jackson, NHOct 18, 1970 · N3899A · Substantial damage NTSB NYC71DFG07Accident · No injuriesClosedCessna 150G · Rochester, NHSep 20, 1970 · N8339J · Substantial damage NTSB NYC71FFG02Accident · Serious injuriesClosedCessna 210 · Clarksville, NHAug 9, 1970 · N7326E · Substantial damage NTSB NYC71DFG05Accident · No injuriesClosedCessna 172 · Wolfeboro, NHJun 2, 1970 · N79578 · Destroyed NTSB NYC70FFG06Accident · No injuriesClosedCessna 172C · Rochester, NHApr 12, 1970 · N8266X · Substantial damage NTSB NYC70FFG03Accident · No injuriesClosedCessna 411 · Claremont, NHMar 13, 1970 · N985J · Substantial damage NTSB NYC70A0057Accident · 3 fatalClosedCessna 172 · Gorham, NHNov 29, 1969 · N6416E · Destroyed NTSB NYC70F0184Accident · Minor injuriesClosedJeane Tenie · Nashua, NHOct 13, 1969 · N8123 · Destroyed NTSB NYC70F0173Accident · No injuriesClosedMeyers 200D · Alstead, NHOct 4, 1969 · N236M · Substantial damage NTSB NYC70D0068Accident · No injuriesClosedCessna 180 · Wolfeboro, NHJul 16, 1969 · N2304C · Substantial damage