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 NYC67F0668Accident · No injuriesClosedPiper PA-28 · Norwood, MAMay 11, 1967 · N4540R · Substantial damage NTSB NYC67F0657Accident · Minor injuriesClosedCessna 150F · Shirley, MAApr 30, 1967 · N8948S · Destroyed NTSB NYC67A0152Accident · 4 fatalClosedBeech 23 · Naushon Isl, MAApr 30, 1967 · N8728M · Destroyed NTSB NYC67D0636Accident · No injuriesClosedPiper PA-28 · Northampton, MAApr 29, 1967 · N7916W · Substantial damage NTSB NYC67F0656Accident · Minor injuriesClosedPiper PA-28 · Norwood, MAApr 26, 1967 · N6758W · Destroyed NTSB NYC67I0138Incident · No injuriesClosedBoeing B-727 · Boston, MAApr 11, 1967 · N6731 · Minor damage NTSB NYC67D0623Accident · No injuriesClosedCessna 182 · Lexington, MAApr 11, 1967 · N2730Q · Substantial damage NTSB NYC67F0631Accident · No injuriesClosedPiper PA-28 · Norwood, MAApr 1, 1967 · N4150J · Substantial damage NTSB NYC67F0588Accident · Minor injuriesClosedCessna 150 · Ludlow, MAApr 1, 1967 · N8214S · Destroyed NTSB NYC67D0667Accident · No injuriesClosedPiper PA-28 · Beverly, MAMar 30, 1967 · N352J · Substantial damage NTSB NYC67A0133Accident · 2 fatalClosedPiper PA-30 · Edgartown, MAMar 28, 1967 · N7801Y · Destroyed NTSB NYC67D0627Accident · No injuriesClosedAeronca L-16 · Newburyport, MAMar 25, 1967 · N1121 · Substantial damage NTSB NYC67D0625Accident · No injuriesClosedCessna 150 · Plymouth, MAMar 21, 1967 · N2454J · Substantial damage NTSB NYC67F0565Accident · No injuriesClosedCessna 210D · North Adams, MAMar 19, 1967 · N3801Y · Substantial damage NTSB NYC67D0621Accident · No injuriesClosedPiper PA-28 · Beverly, MAMar 18, 1967 · N6098W · Substantial damage NTSB NYC67D0615Accident · No injuriesClosedBeech A23A · Marlboro, MAMar 12, 1967 · N2305W · Substantial damage NTSB NYC67D0554Accident · No injuriesClosedHoward DGA-15 · Turner Falls, MAMar 12, 1967 · N5612N · Substantial damage NTSB NYC67D0540Accident · No injuriesClosedPiper PA-28 · North Adams, MAFeb 24, 1967 · N7817W · Substantial damage NTSB NYC67A0119Accident · No injuriesClosedDouglas DC-6B · Mar-Vineyard, MAFeb 22, 1967 · N6255C · Substantial damage NTSB NYC67A0115Accident · No injuriesClosedFairchild FH-227 · Boston, MAFeb 14, 1967 · N374NE · Substantial damage NTSB NYC67D0569Accident · No injuriesClosedMaule M-4 · Norfolk, MAFeb 11, 1967 · N9810M · Substantial damage NTSB NYC67D0479Accident · No injuriesClosedPiper PA-28 · Norwood, MAFeb 9, 1967 · N6758W · Substantial damage NTSB NYC67A0111Accident · 1 fatalClosedPiper PA-28 · Dedham, MAFeb 9, 1967 · N9588J · Destroyed NTSB NYC67F0493Accident · No injuriesClosedBeech A23 · Worcester, MAFeb 3, 1967 · N202GS · Substantial damage NTSB NYC67D0491Accident · No injuriesClosedStits SA-6B · Taunton, MAJan 21, 1967 · N6493C · Substantial damage NTSB NYC67A0104Accident · No injuriesClosedFairchild FH-227 · East Boston, MAJan 20, 1967 · N380NE · Substantial damage NTSB NYC67D0476Accident · No injuriesClosedAeronca 7AC · Turners Fall, MAJan 17, 1967 · N85191 · Substantial damage NTSB NYC67D0427Accident · No injuriesClosedPiper PA-28 · Norwood, MAJan 6, 1967 · N6782W · Substantial damage NTSB NYC67D0455Accident · No injuriesClosedCessna 150 · Sheffield, MADec 30, 1966 · N8663G · Substantial damage NTSB NYC67D0461Accident · No injuriesClosedMooney MK21 · East Boston, MADec 28, 1966 · N9254M · Substantial damage NTSB NYC67D0425Accident · No injuriesClosedCessna 150 · Norwood, MADec 18, 1966 · N3078X · Substantial damage NTSB NYC67F0436Accident · No injuriesClosedCessna 210 · Newburyport, MADec 17, 1966 · N3940Y · Substantial damage NTSB NYC67D0418Accident · No injuriesClosedPiper PA-30 · Plymouth, MADec 13, 1966 · N7801Y · Substantial damage NTSB NYC67F0462Accident · Minor injuriesClosedLuscombe 8A · Norwood, MANov 27, 1966 · N71280 · Substantial damage NTSB NYC67F0402Accident · No injuriesClosedCessna 190 · Newburyport, MANov 24, 1966 · N4314N · Substantial damage NTSB NYC67A0088Accident · 1 fatalClosedPiper J3C-65 · Millis, MANov 24, 1966 · N88669 · Destroyed NTSB NYC67F0354Accident · No injuriesClosedPiper PA-32 · Norwood, MANov 21, 1966 · N3831W · Substantial damage NTSB NYC67D0329Accident · No injuriesClosedPiper J3C-65 · Agawam, MANov 1, 1966 · N70596 · Substantial damage NTSB NYC67D0369Accident · Minor injuriesClosedStinson 108-2 · Hopedale, MAOct 29, 1966 · N1Q · Substantial damage NTSB NYC67A0067Accident · No injuriesClosedBell 47J-2 · Brookline, MAOct 26, 1966 · N73948 · Substantial damage NTSB NYC67D0351Accident · No injuriesClosedBeechcraft A55 · Westfield, MAOct 25, 1966 · N1729G · Substantial damage NTSB NYC67A0062Accident · No injuriesClosedGrumman G-159 · Pittsfield, MAOct 20, 1966 · N363G · Substantial damage NTSB NYC67F0318Accident · No injuriesClosedCessna 150F · Greenfield, MAOct 9, 1966 · N6834F · Substantial damage NTSB NYC67F0404Accident · No injuriesClosedBeech A23-24 · Marlboro, MAOct 2, 1966 · N5784V · Substantial damage NTSB NYC67D0249Accident · No injuriesClosedPiper PA-28 · Hopedale, MASep 18, 1966 · N5716W · Substantial damage NTSB NYC67D0264Accident · No injuriesClosedAeronca 7BCM · Charlton City, MASep 17, 1966 · N1143V · Substantial damage NTSB NYC67A0048Accident · 1 fatalClosedCessna 150 · Westford, MASep 17, 1966 · N8427G · Destroyed NTSB NYC67D0196Accident · No injuriesClosedBeech 35-B33 · Edgartown, MASep 6, 1966 · N4710Y · Substantial damage NTSB NYC67D0259Accident · No injuriesClosedPiper PA-28 · Barre, MASep 5, 1966 · N4697R · Substantial damage NTSB NYC67F0221Accident · Serious injuriesClosedGlobe GC-1A · East Taunton, MAAug 27, 1966 · N90366 · Substantial damage