Skip to content

NTSB investigations, MA

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 NYC75AN036Accident · 1 fatalClosedPiper PA-32 · New Bedford, MASep 9, 1974 · N4088W · Destroyed NTSB NYC75AN033Accident · 1 fatalClosedBellanca 8KCAB · S Weymouth, MASep 8, 1974 · N86589 · Substantial damage NTSB NYC74AN032Accident · No injuriesClosedBell 47G4A · Canton, MASep 6, 1974 · N4034G · Substantial damage NTSB NYC75FNA16Accident · Minor injuriesClosedPiper PA-28 · Stow, MASep 5, 1974 · N5335S · Substantial damage NTSB NYC75FNE09Accident · Serious injuriesClosedAeronca 11BC · E Brookfield, MASep 1, 1974 · N85903 · Substantial damage NTSB NYC75FNA15Accident · No injuriesClosedPiper PA-28 · Marston Mill, MASep 1, 1974 · N1564J · Substantial damage NTSB NYC75DNA12Accident · Serious injuriesClosedSchleicher ASK-14 · Myricks, MAAug 26, 1974 · N8473 · Substantial damage NTSB NYC75FNE08Accident · Serious injuriesClosedCessna 172E · Worcester, MAAug 22, 1974 · N5681T · Substantial damage NTSB NYC75FNA11Accident · Serious injuriesClosedPiper PA-28 · Oak Bluffs, MAAug 16, 1974 · N55405 · Substantial damage NTSB NYC75FNE06Accident · No injuriesClosedCessna 150G · Washington, MAAug 14, 1974 · N3427J · Substantial damage NTSB NYC75FNE07Accident · No injuriesClosedMooney M20C · Fitchburg, MAAug 13, 1974 · N2550W · Substantial damage NTSB NYC75FNE05Accident · No injuriesClosedCessna 172L · Westfield, MAAug 12, 1974 · N4270Q · Substantial damage NTSB NYC75FNA10Accident · No injuriesClosedChampion 7KCAB · Norfolk, MAAug 11, 1974 · N5063X · Substantial damage NTSB NYC75FNE04Accident · Serious injuriesClosedStinson 108-1 · W Springfld, MAAug 9, 1974 · N9740K · Substantial damage NTSB NYC75DNA08Accident · No injuriesClosedBeech B19 · Beverly, MAJul 28, 1974 · N24602 · Substantial damage NTSB NYC75FNA09Accident · No injuriesClosedGrumman G-44A · Norwood, MAJul 27, 1974 · N199T · Substantial damage NTSB NYC75FNE02Accident · Minor injuriesClosedPiper PA-28 · Pittsfield, MAJul 25, 1974 · N7318W · Substantial damage NTSB NYC75DNA06Accident · No injuriesClosedBellanca 7ECA · Marthas Vnyd, MAJul 17, 1974 · N9096L · Destroyed NTSB NYC75DNA04Accident · Minor injuriesClosedCessna 150L · Stow, MAJul 13, 1974 · N11386 · Substantial damage NTSB NYC75AN005Accident · 1 fatalClosedGlobe GC-1B · Plum Island, MAJul 13, 1974 · N3342K · Destroyed NTSB NYC74FNA05Accident · Serious injuriesClosedPiper PA-30 · Provincetown, MAJul 13, 1974 · N9000R · Substantial damage NTSB NYC75FNA03Accident · No injuriesClosedCorbin Baby ACE C · Tewksbury, MAJul 7, 1974 · N6575D · Substantial damage NTSB NYC75FNA02Accident · No injuriesClosedCessna U206B · Newburyport, MAJul 4, 1974 · N3893G · Substantial damage NTSB NYC75FNA01Accident · Minor injuriesClosedRepublic RC-3 · Norwood, MAJul 4, 1974 · N6661K · Substantial damage NTSB NYC74FNA43Accident · Minor injuriesClosedStinson 108-1 · Bourne, MAJun 9, 1974 · N97154 · Substantial damage NTSB NYC74FNE28Accident · No injuriesClosedCessna 172K · Palmer, MAJun 8, 1974 · N84398 · Substantial damage NTSB NYC74FNA42Accident · No injuriesClosedPiper PA-24 · Newburyport, MAJun 8, 1974 · N892RC · Substantial damage NTSB NYC74FN105Accident · No injuriesClosedBeech G18S · East Boston, MAJun 6, 1974 · N542B · Substantial damage NTSB NYC74AN097Accident · 3 fatalClosedPiper PA-28R · Tewksbury, MAMay 20, 1974 · N4MB · 2 aircraft · Destroyed NTSB NYC74FNE25Accident · No injuriesClosedPiper PA-28 · Sterling, MAMay 16, 1974 · N9688W · Substantial damage NTSB NYC74FNE23Accident · Serious injuriesClosedCessna 150F · Monterey, MAMay 12, 1974 · N8234F · Destroyed NTSB NYC74FNE18Accident · No injuriesClosedPiper PA-28 · Northampton, MAApr 23, 1974 · N4226T · Substantial damage NTSB NYC74FNA41Accident · Serious injuriesClosedSchweizer 2-33 · Plymouth, MAApr 21, 1974 · N2489W · Substantial damage NTSB NYC74FNA40Accident · No injuriesClosedPiper PA-28 · Norwood, MAApr 20, 1974 · N55283 · Substantial damage NTSB NYC74IN089IncidentClosedLockheed 1011 · East Boston, MAApr 19, 1974 · N31007 · Destroyed NTSB NYC74AN086Accident · No injuriesClosedCessna 310Q · Worcester, MAApr 10, 1974 · N8240Q · Substantial damage NTSB NYC74AN084Accident · 4 fatalClosedPiper PA-23 · Nantucket, MAApr 2, 1974 · N4623P · Destroyed NTSB NYC74FNA39Accident · No injuriesClosedPiper PA-28 · Marthas Vyrd, MAMar 22, 1974 · N5510U · Substantial damage NTSB NYC74DNA38Accident · No injuriesClosedAero Comdr 100A · Haverhill, MAMar 9, 1974 · N4041X · Substantial damage NTSB NYC74DNA37Accident · No injuriesClosedMooney M20F · Norwood, MAMar 9, 1974 · N3819N · Substantial damage NTSB NYC74AN074Accident · 2 fatalClosedCessna 172 · Swansea, MAMar 2, 1974 · N35526 · Destroyed NTSB NYC74FNA36Accident · No injuriesClosedPiper PA-22 · Ipswich, MAFeb 27, 1974 · N2850Z · Substantial damage NTSB NYC74DNA35Accident · No injuriesClosedCessna 206 · Nantucket, MAFeb 23, 1974 · N70594 · Substantial damage NTSB NYC74DNA34Accident · No injuriesClosedCessna 172 · Plymouth, MAFeb 18, 1974 · N46292 · Substantial damage NTSB NYC74IN070Incident · No injuriesClosedDouglas DC-8 · Nantucket, MAFeb 17, 1974 · N8639 · No damage NTSB NYC74FNE16Accident · No injuriesClosedAero Comdr 680F · Worcester, MAFeb 13, 1974 · N188D · Substantial damage NTSB NYC74FNE15Accident · No injuriesClosedPiper J3C-65 · Windsor, MAFeb 6, 1974 · N87926 · Substantial damage NTSB NYC74FNE14Accident · Serious injuriesClosedMooney M20 · Easthampton, MAJan 27, 1974 · N5260B · Destroyed NTSB NYC74FNA33Accident · Minor injuriesClosedPiper PA-28 · Plympton, MAJan 26, 1974 · N55904 · Destroyed NTSB NYC74DNA32Accident · No injuriesClosedCessna 172 · Marlboro, MAJan 25, 1974 · N4261L · Substantial damage