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 NYC68F0066Accident · No injuriesClosedMooney M20C · Rochester, NHJun 24, 1967 · N7874V · Substantial damage NTSB NYC67I0158Incident · Serious injuriesClosedBensen B-8M · Hooksett, NHMay 14, 1967 · NNONE · Minor damage NTSB NYC67A0159Accident · 2 fatalClosedCessna 150G · Nashua, NHMay 14, 1967 · N3755J · Destroyed NTSB NYC67F0653Accident · No injuriesClosedPiper PA-18A · Nashua, NHMay 3, 1967 · N1866A · Substantial damage NTSB NYC67D0589Accident · No injuriesClosedCessna 182 · Concord, NHApr 2, 1967 · N2800Y · Substantial damage NTSB NYC67D0561Accident · Minor injuriesClosedCessna 175 · Claremont, NHMar 25, 1967 · N6574E · Substantial damage NTSB NYC67F0548Accident · No injuriesClosedBeech C35 · Rochester, NHMar 11, 1967 · N1814D · Substantial damage NTSB NYC67D0538Accident · No injuriesClosedCessna 140 · Nashua, NHMar 2, 1967 · N73096 · Substantial damage NTSB NYC67D0537Accident · No injuriesClosedLuscombe 8A · Keene, NHMar 2, 1967 · N2867K · Substantial damage NTSB NYC67F0516Accident · Serious injuriesClosedCessna P206A · Laconia, NHFeb 3, 1967 · N2511X · Destroyed NTSB NYC67D0430Accident · No injuriesClosedCessna 172 · Hampton, NHJan 7, 1967 · N8870B · Substantial damage NTSB NYC67D042.Accident · No injuriesClosedPiper PA-22 · Jaffrey, NHDec 31, 1966 · N5805Z · Substantial damage NTSB NYC67A0072Accident · 2 fatalClosedPiper PA-24 · Manchester, NHNov 1, 1966 · N8027P · Destroyed NTSB NYC67D0321Accident · No injuriesClosedPiper PA-28 · Milford, NHOct 23, 1966 · N7581W · Substantial damage NTSB NYC67D0311Accident · Minor injuriesClosedSchleicher KA-6 · Gorham, NHOct 8, 1966 · N6574D · Destroyed NTSB NYC67D0273Accident · No injuriesClosedPiper PA-22 · Colebrook, NHAug 25, 1966 · N3556P · Substantial damage NTSB NYC67D0242Accident · No injuriesClosedCessna 210 · Nashua, NHAug 20, 1966 · N3850Y · Substantial damage NTSB NYC67A0027Accident · 2 fatalClosedNavion NAV-4 · Ashuelot, NHAug 15, 1966 · N4364K · Destroyed NTSB NYC67F0083Accident · No injuriesClosedBeech A23 · Manchester, NHJul 21, 1966 · N1493L · Substantial damage NTSB NYC67D0008Accident · No injuriesClosedPiper J3 · Laconia, NHMay 30, 1966 · N98536 · Substantial damage NTSB NYC66F0679Accident · Minor injuriesClosedPiper PA-24 · Bristol, NHMay 15, 1966 · B314VW · Substantial damage NTSB NYC66D0659Accident · No injuriesClosedAeronca 7AC · Derry, NHMay 10, 1966 · N81745 · Substantial damage NTSB NYC66F0660Accident · No injuriesClosedAeronca 7AC · Pelham, NHMay 8, 1966 · N84242 · Substantial damage NTSB NYC66F0613Accident · No injuriesClosedBeechcraft 23 · Claremont, NHApr 17, 1966 · N2315Z · Substantial damage NTSB NYC66F0614Accident · No injuriesClosedLuscombe 8F · Keene, NHApr 12, 1966 · N77867 · Substantial damage NTSB NYC66D0596Accident · No injuriesClosedPiper PA-22 · Twin Mountain, NHMar 26, 1966 · N3206B · Substantial damage NTSB NYC66A0103Accident · 1 fatalClosedCessna 182 · Campton, NHMar 19, 1966 · N8958T · Destroyed NTSB NYC66F0560Accident · No injuriesClosedAeronca 7AC · Claremont, NHMar 8, 1966 · N84522 · Substantial damage NTSB NYC66A0072Accident · No injuriesClosedPiper PA-28 · Hampton, NHJan 7, 1966 · N8170W · Substantial damage NTSB NYC66D0436Accident · No injuriesClosedPiper PA-28 · Manchester, NHDec 22, 1965 · N6642W · Substantial damage NTSB NYC66F0252Accident · Serious injuriesClosedTaylorcraft BC12D · Derry, NHSep 22, 1965 · N5210M · Substantial damage NTSB NYC66F0228Accident · Serious injuriesClosedFairchild 24R46A · Belmont, NHSep 2, 1965 · N81300 · Destroyed NTSB NYC66F0193Accident · Minor injuriesClosedCessna 150D · Franconia, NHAug 30, 1965 · N4556U · Substantial damage NTSB NYC66D0215Accident · No injuriesClosedPiper PA-18S · Kingston, NHAug 29, 1965 · N8072C · Substantial damage NTSB NYC66D0143Accident · No injuriesClosedPiper PA22 · Warren, NHJul 25, 1965 · CFRNT · Substantial damage NTSB NYC66F0089Accident · No injuriesClosedCessna 120 · Rochester, NHJul 7, 1965 · N66350 · Destroyed NTSB NYC66F0005Accident · Serious injuriesClosedPiper PA12 · Weare, NHJun 13, 1965 · N7928H · Destroyed NTSB NYC65F0231Accident · Minor injuriesClosedMaule M-4 · Melvin Village, NHJun 8, 1965 · N4708T · Destroyed NTSB NYC65F0183Accident · No injuriesClosedCessna 140 · Rochester, NHApr 21, 1965 · N2440N · Substantial damage NTSB NYC65F0081Accident · No injuriesClosedCessna 182 · Hampton, NHApr 2, 1965 · N8512T · Substantial damage NTSB NYC65F0082Accident · No injuriesClosedPiper PA-22 · Claremont, NHMar 12, 1965 · N1233C · Substantial damage NTSB NYC65F0083Accident · No injuriesClosedCessna 150 · Stratford, NHMar 9, 1965 · N6567T · Substantial damage NTSB NYC65F0077Accident · No injuriesClosedCessna 185 · Groveton, NHFeb 20, 1965 · N4164Y · Substantial damage NTSB NYC65F0061Accident · No injuriesClosedBeechraft P-35 · Nashua, NHFeb 13, 1965 · N8585M · Substantial damage NTSB NYC65F0060Accident · Minor injuriesClosedPiper PA-30 · Laconia, NHFeb 4, 1965 · N7267Y · Destroyed NTSB NYC65F0045Accident · No injuriesClosedCessna 140 · Rochester, NHJan 28, 1965 · N2440N · Substantial damage NTSB NYC65F0035Accident · No injuriesClosedLuscombe 8A · Rochester, NHJan 23, 1965 · N1808B · Substantial damage NTSB UNK65X1305Accident · Minor injuriesClosedPiper PA-22 · Nashua, NHJan 17, 1965 · N5939Z · 2 aircraft · Substantial damage NTSB UNK65X1233Accident · No injuriesClosedPiper PA12 · Grafton, NHJan 5, 1965 · N4408M · Substantial damage NTSB UNK65X1194Accident · No injuriesClosedAero Cmdr 560E · Laconia, NHDec 31, 1964 · N3827C · Substantial damage