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 NYC75AN063Accident · 2 fatalClosedPiper L-4B · Rochester, NHNov 16, 1974 · N142H · Substantial damage NTSB NYC75FNC18Accident · No injuriesClosedCessna 150L · Nashua, NHNov 9, 1974 · N11392 · Substantial damage NTSB NYC75FNC14Accident · Serious injuriesClosedPiper PA-28 · Gilford, NHOct 13, 1974 · N8086W · Substantial damage NTSB NYC75FNC13Accident · No injuriesClosedLake LA-4 · Lancaster, NHOct 4, 1974 · N65713 · Substantial damage NTSB NYC75FNC09Accident · No injuriesClosedCessna 140 · Nashua, NHSep 22, 1974 · N4006N · Substantial damage NTSB NYC75FNC08Accident · Serious injuriesClosedBeech B19 · Berlin, NHAug 30, 1974 · N74WG · Substantial damage NTSB NYC75AN023Accident · 2 fatalClosedCessna 340 · Whitefield, NHAug 24, 1974 · N5AM · Destroyed NTSB NYC75AN010Accident · 1 fatalClosedCessna 172K · Jaffrey, NHJul 21, 1974 · N84330 · Minor damage NTSB NYC75FNC04Accident · Minor injuriesClosedGrumman TR-2 · Twin Mountain, NHJul 13, 1974 · N9962L · Substantial damage NTSB NYC75FNC02Accident · No injuriesClosedViking B-8 · Laconia, NHJul 13, 1974 · N975M · Substantial damage NTSB NYC74DNC47Accident · No injuriesClosedAero Comdr 100 · Brookline, NHJun 13, 1974 · N3790X · Substantial damage NTSB NYC74DNC45Accident · No injuriesClosedPitts S-2A · Jaffrey, NHJun 8, 1974 · N388N · 2 aircraft · Substantial damage NTSB NYC74FNC41Accident · Minor injuriesClosedCessna 305A · N Conway, NHMay 2, 1974 · N1836 · Substantial damage NTSB NYC74DNC39Accident · No injuriesClosedSchweizer SG1-26 · Hollis, NHApr 20, 1974 · N1109S · Destroyed NTSB NYC74DNC38Accident · No injuriesClosedCessna 140 · Wolfeboro, NHFeb 13, 1974 · N3648V · Substantial damage NTSB NYC74FNC35Accident · No injuriesClosedAmer Avco AA1-B · Manchester, NHJan 15, 1974 · N9998L · Substantial damage NTSB NYC74FNC34Accident · No injuriesClosedCessna R172E · Jaffrey, NHJan 13, 1974 · N65177 · Substantial damage NTSB NYC74AN060Accident · Serious injuriesClosedDouglas DC-9 · Lebanon, NHDec 21, 1973 · N3338L · No damage NTSB NYC74AN050Accident · 1 fatalClosedPiper PA-23 · Hanover, NHNov 28, 1973 · N13978 · Destroyed NTSB NYC74DNC29Accident · No injuriesClosedCessna 140 · Gilmanton, NHNov 4, 1973 · N353T · Substantial damage NTSB NYC74AN036Accident · 1 fatalClosedAmer Avco AA1 · Temple, NHOct 25, 1973 · N5700L · Destroyed NTSB NYC74DNC26Accident · No injuriesClosedWaco UPF-7 · North Conway, NHOct 7, 1973 · N169V · 2 aircraft · Substantial damage NTSB NYC74DNC22Accident · No injuriesClosedCessna 150 · Canaan, NHSep 29, 1973 · N18237 · Substantial damage NTSB NYC74DNC75Accident · No injuriesClosedPiper PA-18 · Lebanon, NHSep 25, 1973 · N13814 · Substantial damage NTSB NYC74DNC21Accident · No injuriesClosedSchweizer 126 · Franconia, NHSep 4, 1973 · N1118S · Destroyed NTSB NYC74DNC19Accident · No injuriesClosedCessna 182K · Melvin Village, NHAug 27, 1973 · N2619Q · Substantial damage NTSB NYC74DNC16Accident · No injuriesClosedPiper J-3 · Hill, NHAug 16, 1973 · N5580 · Substantial damage NTSB NYC74AN008Accident · 3 fatalClosedPiper PA-28 · Gilford, NHJul 28, 1973 · N9492 · Destroyed NTSB NYC74FNC10Accident · No injuriesClosedCessna 182N · Claremont, NHJul 17, 1973 · N92330 · Substantial damage NTSB NYC74FNC08Accident · No injuriesClosedAmer Avco AA1 · Rochester, NHJul 17, 1973 · N5773L · Substantial damage NTSB NYC71AN003Accident · 1 fatalClosedPiper PA-28 · Northwood, NHMay 28, 1973 · N5553F · Destroyed NTSB NYC73AN143Accident · 1 fatalClosedCessna 205 · Francistown, NHMay 18, 1973 · N8428Z · Destroyed NTSB NYC73FNC72Accident · No injuriesClosedAmer Avco AA-1 · Manchester, NHMay 1, 1973 · N6139L · Substantial damage NTSB NYC73FNC71Accident · Minor injuriesClosedPiper PA-17 · Hillsborough, NHApr 30, 1973 · N4615H · Substantial damage NTSB NYC73FNC67Accident · Minor injuriesClosedAeronca 15AC · Pelham, NHApr 16, 1973 · N1136H · Substantial damage NTSB NYC73DNC68Accident · No injuriesClosedMooney M20E · North Conway, NHApr 7, 1973 · N3241F · Substantial damage NTSB NYC73DNC57Accident · No injuriesClosedPiper PA-28R · Concord, NHMar 10, 1973 · N3298R · Substantial damage NTSB NYC73DNC51Incident · No injuriesClosedBeech A23A · Claremont, NHFeb 4, 1973 · N202GS · Minor damage NTSB NYC73FNC50Accident · No injuriesClosedCessna 140 · Manchester, NHJan 24, 1973 · N1995N · Substantial damage NTSB UNK73X0105Incident · No injuriesClosedChampion 7GC · Claremont, NHJan 14, 1973 · N4832E · Minor damage NTSB NYC73DNC48Accident · No injuriesClosedBeech 23 · Claremont, NHJan 14, 1973 · N2315Z · Substantial damage NTSB NYC73AN102Accident · Minor injuriesClosedCessna 150 · Nashua, NHJan 14, 1973 · N4239U · 2 aircraft · Substantial damage NTSB NYC73ANC46Accident · No injuriesClosedPiper PA-28 · Nashua, NHJan 11, 1973 · N15320 · Substantial damage NTSB NYC73FNC45Accident · No injuriesClosedPiper PA-24 · Keene, NHJan 1, 1973 · N4250 · Substantial damage NTSB NYC73AN064Accident · 1 fatalClosedMooney A2-A · Gilmanton, NHNov 7, 1972 · N5490F · Destroyed NTSB NYC73AN058Accident · 2 fatalClosedPiper PA-22 · Candia, NHOct 28, 1972 · N844A · Destroyed NTSB NYC73ANO51Accident · No injuriesClosedPiper PA-31 · West Lebanon, NHOct 13, 1972 · N76LE · Substantial damage NTSB NYC73DNC24Accident · No injuriesClosedPiper PA-28 · Wentworth, NHSep 20, 1972 · N5534F · Substantial damage NTSB NYC73AN049Accident · No injuriesClosedCessna 337 · Laconia, NHAug 21, 1972 · N1811M · 2 aircraft · Substantial damage NTSB NYC73DNC20Accident · No injuriesClosedRepublic RC3 · Melvin Village, NHAug 9, 1972 · N451E · Substantial damage