Skip to content

NTSB investigations, MA

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 NYC73DNA49Accident · No injuriesClosedPiper J-3 · N.Andover, MAMay 27, 1973 · N42739 · Substantial damage NTSB NYC73FNE33Accident · No injuriesClosedCessna 150L · Northamton, MAMay 13, 1973 · N18678 · Substantial damage NTSB NYC73FNA48Accident · Serious injuriesClosedBlanik L-13 · Plymouth, MAMay 12, 1973 · N12YA · Substantial damage NTSB NYC73FNA47Accident · Serious injuriesClosedPiper PA-23 · Wenham, MAMay 10, 1973 · N5991Y · Destroyed NTSB NYC73AN139Accident · 4 fatalClosedBeech V35A · Methuen, MAMay 9, 1973 · N8335N · Destroyed NTSB NYC73FNA46Accident · No injuriesClosedMooney M20C · Hyannis, MAMay 6, 1973 · N6863N · Substantial damage NTSB NYC73DNA45Accident · No injuriesClosedPiper PA-24 · S.Weymouth, MAApr 28, 1973 · N8430P · Substantial damage NTSB NYC73FNE30Accident · No injuriesClosedCook Tern · North Adams, MAApr 25, 1973 · N4705 · Substantial damage NTSB NYC73DNA44Accident · No injuriesClosedPiper PA-28 · Taunton, MAApr 21, 1973 · N3940K · Substantial damage NTSB NYC73ANA43Accident · Minor injuriesClosedPiper PA-28 · Fall River, MAApr 19, 1973 · N7577R · Destroyed NTSB NYC73AN133Accident · 1 fatalClosedCessna 150 · Princeton, MAApr 16, 1973 · N19057 · Destroyed NTSB NYC73FNA42Accident · Minor injuriesClosedPiper PA-22 · Taunton, MAApr 14, 1973 · N8596C · Substantial damage NTSB NYC73FNA47Accident · No injuriesClosedPiper PA-23 · Norwood, MAMar 22, 1973 · N6900Y · Substantial damage NTSB NYC73DNE25Accident · No injuriesClosedPiper PA-16 · Turner Falls, MAMar 9, 1973 · N5383H · Substantial damage NTSB NYC73FNE21Accident · No injuriesClosedPiper PA-22 · Westboro, MAFeb 28, 1973 · N9151D · Substantial damage NTSB NYC73DNA40Accident · No injuriesClosedCessna 150 · Hyannis, MAFeb 23, 1973 · N6209G · Substantial damage NTSB NYC73FNA38Accident · Serious injuriesClosedAeronca 7AC · Beverly, MAFeb 19, 1973 · N83022 · Substantial damage NTSB NYC73ANA39Accident · No injuriesClosedBeech B23 · Stow, MAFeb 18, 1973 · N7619R · Substantial damage NTSB NYC73FNA37Accident · No injuriesClosedCessna 195B · Tewksbury, MAFeb 3, 1973 · N2117C · Substantial damage NTSB NYC73AN108Accident · 1 fatalClosedCessna 150 · Taunton, MAFeb 3, 1973 · N5499Q · Destroyed NTSB NYC73DNA36Accident · Minor injuriesClosedCessna 172L · Nantucket, MAJan 29, 1973 · N100DF · Substantial damage NTSB NYC73FNE18Accident · No injuriesClosedSport-Aire Iiss · Westfield, MAJan 16, 1973 · N10041 · Substantial damage NTSB NYC73FNA34Accident · No injuriesClosedAero Comdr 100 · Newburyport, MAJan 14, 1973 · N3683X · Substantial damage NTSB NYC73FNE14Accident · No injuriesClosedErco 415-E · Oakham, MAJan 3, 1973 · N94771 · Substantial damage NTSB NYC73FNA33Accident · No injuriesClosedEnstrom F-28A · Marshfield, MADec 23, 1972 · N4879 · Substantial damage NTSB NYC73DNA32Accident · No injuriesClosedTaylorcraft BL1265 · E.Falmouth, MADec 19, 1972 · N34035 · Destroyed NTSB NYC73FNE13Accident · No injuriesClosedCessna 170 · Turner Falls, MADec 18, 1972 · N2587V · Substantial damage NTSB NYC73FNE11Accident · No injuriesClosedPiper PA-28 · Oxford, MADec 9, 1972 · N613FL · Substantial damage NTSB NYC73FNA31Accident · Minor injuriesClosedCessna 150K · Middleboro, MANov 19, 1972 · N6294G · Substantial damage NTSB NYC73AN068Accident · Serious injuriesClosedCessna 172E · Tewksbury, MANov 19, 1972 · N5603T · 2 aircraft · Substantial damage NTSB NYC73FNA30Accident · No injuriesClosedAmer Avco AA1A · Haverhill, MANov 12, 1972 · N6378L · Substantial damage NTSB NYC72FNA29Accident · No injuriesClosedCessna 310I · New Bedford, MAOct 25, 1972 · N922GB · Substantial damage NTSB NYC73DNA28Accident · No injuriesClosedPiper PA-28 · Taunton, MAOct 14, 1972 · N98289 · Substantial damage NTSB NYC73DNA25Accident · No injuriesClosedCessna 182 · Falmouth, MAOct 10, 1972 · N9211G · Substantial damage NTSB NYC73FNA23Accident · Minor injuriesClosedMooney M20E · Lexington, MAOct 9, 1972 · N6938U · Substantial damage NTSB NYC72DNA24Accident · No injuriesClosedCessna 180 · Chatham, MAOct 9, 1972 · N481D · Substantial damage NTSB NYC73FNA22Accident · No injuriesClosedCessna 150 · Bedford, MAOct 4, 1972 · N6346G · Substantial damage NTSB NYC73DNA27Accident · Minor injuriesClosedPiper PA-22 · Edgartown, MASep 24, 1972 · N4692Z · Destroyed NTSB NYC73FNA20Accident · No injuriesClosedCessna 177 · Oak Bluffs, MASep 8, 1972 · N34201 · Substantial damage NTSB NYC73DNA21Accident · No injuriesClosedAmer Avco AA-1 · Hopedale, MAAug 23, 1972 · N9413L · Substantial damage NTSB NYC73FNA14Accident · No injuriesClosedBlanik L-13 · Plymouth, MAAug 20, 1972 · N11YA · Substantial damage NTSB NYC73DNA13Accident · No injuriesClosedCessna 150J · Middleboro, MAAug 17, 1972 · N60248 · Substantial damage NTSB NYC73AN029Accident · 2 fatalClosedBrantly B-2B · Duxbury, MAAug 15, 1972 · N2254U · Destroyed NTSB NYC73AN028Accident · 5 fatalClosedCessna 172I · Hopedale, MAAug 15, 1972 · N752ST · Destroyed NTSB NYC73FNA12Accident · Serious injuriesClosedPiper PA-32 · Nantucket, MAAug 13, 1972 · N4196R · Substantial damage NTSB NYC73FNA11Accident · Serious injuriesClosedCessna 177 · Nantucket, MAAug 10, 1972 · N3225T · Substantial damage NTSB NYC73IN023Incident · No injuriesClosedAerostar 601 · Boston, MAAug 3, 1972 · N7450S · Minor damage NTSB NYC73FNA09Accident · Serious injuriesClosedPiper PA-28 · Haverhill, MAAug 2, 1972 · N5813U · Destroyed NTSB NYC73FNA08Accident · No injuriesClosedCessna 150 · Norwood, MAJul 30, 1972 · N5907G · Substantial damage NTSB NYC73AN018Accident · 2 fatalClosedTaylorcraft L-2B · No.Andover, MAJul 30, 1972 · N47120 · Destroyed