Skip to content

NTSB investigations, MA

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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" = 'MA' 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\" = 'MA' 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" = 'MA' 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 NYC66F0091Accident · No injuriesClosedPiper J3C · Hopedale, MAJul 3, 1965 · N6213H · Substantial damage NTSB NYC65A0157Accident · No injuriesClosedAir & Space 18A · Pocasset, MAJun 28, 1965 · N6103S · Substantial damage NTSB NYC66D0036Accident · No injuriesClosedBeechcraft 23 · Tewksbury, MAJun 27, 1965 · N23441 · Substantial damage NTSB NYC66D0047Accident · No injuriesClosedStinson SM-8A · Provincetown, MAJun 20, 1965 · N205W · Substantial damage NTSB NYC66F0025Accident · No injuriesClosedCessna 195B · East Boston, MAJun 13, 1965 · N3070B · Substantial damage NTSB NYC66F0007Accident · Minor injuriesClosedAeronca 7AC · Hanson, MAJun 6, 1965 · N84436 · Substantial damage NTSB NYC66F0013Accident · No injuriesClosedPiper J-3 · Tewksbury, MAJun 3, 1965 · N186CM · Minor damage NTSB NYC65F0169Accident · No injuriesClosedPiper PA-22 · Danvers, MAMay 10, 1965 · N1849A · Substantial damage NTSB NYC65F0178Accident · No injuriesClosedLuscombe T8F · Shirley, MAMay 9, 1965 · N2058B · Substantial damage NTSB NYC66F0038Accident · No injuriesClosedCessna 150 · Tewksbury, MAMay 8, 1965 · N3963U · Substantial damage NTSB NYC65F0145Accident · Minor injuriesClosedCessna 172 · Westboro, MAMay 4, 1965 · N1497Y · Substantial damage NTSB 16065F0160Accident · No injuriesClosedPiper PA-24 · Norwood, MAMay 2, 1965 · N6322P · Substantial damage NTSB NYC65F0148Accident · Serious injuriesClosedTaylorcraft BCS12D · Cheshire, MAApr 25, 1965 · N94962 · Substantial damage NTSB NYC65F0121Accident · No injuriesClosedBeechraft D-18S · Boston, MAApr 15, 1965 · N80344 · Substantial damage NTSB NYC65F0139Accident · No injuriesClosedBeechcraft C-18S · Ayer, MAApr 9, 1965 · N6534D · Substantial damage NTSB NYC65D0188Accident · No injuriesClosedCessna 310D · Beverly, MAApr 9, 1965 · N6950T · Substantial damage NTSB NYC65F0170Accident · No injuriesClosedLuscombe 8E · Haverhill, MAApr 6, 1965 · N2269K · Substantial damage NTSB NYC65F0092Accident · No injuriesClosedTaylorcraft BC-12D · Newburyport, MAApr 3, 1965 · N95148 · Substantial damage NTSB NYC65A0119Accident · 1 fatalClosedBell 47J2 · Boston, MAMar 28, 1965 · N73215 · Destroyed NTSB NYC65F0093Accident · No injuriesClosedCessna 150 · Ware, MAMar 16, 1965 · N4209U · Substantial damage NTSB NYC65F0069Accident · No injuriesClosedCessna 172 · Haverhill, MAFeb 28, 1965 · N7111A · Substantial damage NTSB NYC65F0047Accident · No injuriesClosedCessna 172 · Tewksbury, MAFeb 21, 1965 · N7611T · Substantial damage NTSB NYC65F0044Accident · No injuriesClosedPiper PA22 · Hyannis, MAFeb 17, 1965 · N4975Z · Substantial damage NTSB NYC65F0064Accident · No injuriesClosedBeechraft E-35 · Marlboro, MAFeb 14, 1965 · N3552B · Substantial damage NTSB NYC65F0008Accident · No injuriesClosedPiper PA22 · Barre, MAFeb 7, 1965 · N5973Z · Substantial damage NTSB UNK65X1398Accident · No injuriesClosedChampion 7FC · Tewksbury, MAFeb 6, 1965 · N9900Y · Substantial damage NTSB OAK65F0006Accident · No injuriesClosedCessna 120 · Quincy Calif, MAFeb 6, 1965 · N2983N · Substantial damage NTSB NYC65F0014Accident · No injuriesClosedPiper PA18 · Ayer, MAFeb 5, 1965 · N10131 · Substantial damage NTSB NYC65F0036Accident · No injuriesClosedCessna 172 · Andover, MAFeb 4, 1965 · N7859U · Substantial damage NTSB NYC65F0006Accident · No injuriesClosedPiper PA22 · Tewksbury, MAFeb 3, 1965 · N5647Z · Substantial damage NTSB NYC65F0029Accident · No injuriesClosedLuscombe 8A · Newbury, MAJan 31, 1965 · N25355 · Substantial damage NTSB UNK65X1369Accident · No injuriesClosedPiper PA28 · Norwood, MAJan 29, 1965 · N7479W · Substantial damage NTSB UNK65X1333Accident · No injuriesClosedPiper J5A · Tewksbury, MAJan 22, 1965 · N26946 · Substantial damage NTSB UNK65X1316Accident · No injuriesClosedPiper PA22 · Edgarton, MAJan 19, 1965 · N9765D · Substantial damage NTSB UNK65X1286Accident · No injuriesClosedCessna 172 · Worcester, MAJan 14, 1965 · N5627A · Substantial damage NTSB UNK65X1261Accident · No injuriesClosedFairchild 24W41A · Norwood, MAJan 9, 1965 · N25183 · Substantial damage NTSB UNK65X1216Accident · No injuriesClosedCessna 140 · Millbury, MAJan 2, 1965 · N90136 · Substantial damage NTSB UNK65X1020Accident · No injuriesClosedBellanca 14-13 · Lexington, MADec 15, 1964 · N86803 · Destroyed NTSB UNK65X1001Accident · No injuriesClosedDehavilland DH104 · Worcester, MADec 13, 1964 · N357G · Substantial damage NTSB UNK65X0979Accident · No injuriesClosedBeechcraft H18 · Worcester, MADec 11, 1964 · N919X · Substantial damage NTSB UNK65X0805Accident · No injuriesClosedBeechcraft E18 · East Boston, MANov 23, 1964 · N432U · Substantial damage NTSB UNK65X0798Accident · No injuriesClosedCessna 150 · Agawam, MANov 22, 1964 · N5889E · Substantial damage NTSB UNK65X0507Accident · No injuriesClosedStinson 108-3 · Plympton, MANov 1, 1964 · N4145C · Substantial damage NTSB UNK65X0221Accident · No injuriesClosedCessna 150 · Hanson, MAOct 10, 1964 · N7728E · Substantial damage NTSB UNK64X4181Accident · No injuriesClosedCessna 180 · Norwood, MASep 27, 1964 · N2951C · Substantial damage NTSB UNK64X4163Accident · No injuriesClosedPiper PA28 · Norwood, MASep 26, 1964 · N6235W · Substantial damage NTSB UNK64X4021Accident · No injuriesClosedCessna 172A · Beverly, MASep 17, 1964 · N9712T · Minor damage NTSB UNK64X3998Accident · No injuriesClosedPiper PA24 · Bedford, MASep 16, 1964 · N5048P · Substantial damage NTSB UNK64X3936Accident · No injuriesClosedPiper PA22 · Nantucket, MASep 12, 1964 · N9631D · Destroyed NTSB UNK64X3826Accident · No injuriesClosedLuscombe 8E · Kingston, MASep 6, 1964 · N1587B · Substantial damage