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 NYC72DNE07Accident · No injuriesClosedPiper PA-23 · West Milbury, MAAug 13, 1971 · N6848Y · Substantial damage NTSB NYC72FNE11Accident · Minor injuriesClosedBeech 35C33A · Deerfield, MAAug 12, 1971 · N1866C · Substantial damage NTSB NYC72FNA07Accident · No injuriesClosedChampion 7ECA · West Tisbury, MAAug 12, 1971 · N2572F · Substantial damage NTSB NYC72DNA08Accident · No injuriesClosedCessna 182N · Marlboro, MAAug 7, 1971 · N722HV · Substantial damage NTSB NYC72AN025Accident · 3 fatalClosedBeech B23 · Stow, MAAug 5, 1971 · N6138N · Destroyed NTSB NYC72FNA05Accident · No injuriesClosedBell 47D · Carver, MAAug 4, 1971 · N177B · Substantial damage NTSB NYC72AN018Accident · No injuriesClosedCessna 402 · New Bedford, MAAug 2, 1971 · N8125F · Substantial damage NTSB NYC72FNA03Accident · No injuriesClosedPiper PA-18 · Haverhill, MAJul 23, 1971 · N8118 · Substantial damage NTSB NYC72FNA02Accident · No injuriesClosedCessna 310 · M.Vineyard, MAJul 11, 1971 · N4881B · Substantial damage NTSB NYC72FNE01Accident · Minor injuriesClosedLake LA-4 · Southwick, MAJul 6, 1971 · N2015L · Substantial damage NTSB NYC72FNA01Accident · No injuriesClosedPiper PA-28 · Norwood, MAJul 6, 1971 · N5396S · Substantial damage NTSB NYC71FNA57Accident · No injuriesClosedMooney M20F · Tewksbury, MAJun 30, 1971 · N9456V · Substantial damage NTSB NYC71FNA58Accident · No injuriesClosedPiper PA-20 · Taunton, MAJun 29, 1971 · N7745K · Substantial damage NTSB NYC71DNE45Accident · Minor injuriesClosedCessna 150D · Pittsville, MAJun 23, 1971 · N4362U · Substantial damage NTSB NYC71IN125Incident · No injuriesClosedDouglas DC9-31 · Marthas Vnyd, MAJun 22, 1971 · N982NE · Minor damage NTSB NYC71DNE44Accident · No injuriesClosedDehavilland DH 82A · Southbridge, MAJun 20, 1971 · N40DH · Substantial damage NTSB NYC71FNA55Accident · Serious injuriesClosedPiper PA-28 · Hanover, MAJun 19, 1971 · N5710U · Substantial damage NTSB NYC71FNA56Accident · No injuriesClosedPiper PA-28 · Norwood, MAJun 16, 1971 · N1760J · Substantial damage NTSB NYC71FNA53Accident · No injuriesClosedMooney M20C · Middleboro, MAJun 13, 1971 · N1349W · Substantial damage NTSB NYC71DNA52Accident · No injuriesClosedCessna 172 · Marlborough, MAJun 12, 1971 · N36625 · Substantial damage NTSB NYC71DNA54Accident · No injuriesClosedPiper PA-24 · Hyannis, MAJun 8, 1971 · N5759P · Substantial damage NTSB NYC71FNA51Accident · No injuriesClosedPiper PA-28 · Oak Bluffs, MAJun 6, 1971 · N5695W · Substantial damage NTSB NYC71FNA59Accident · No injuriesClosedDehavilland DH 104 · East Boston, MAJun 2, 1971 · N375JC · Substantial damage NTSB NYC71DNA50Accident · No injuriesClosedPiper PA-28 · Marshfield, MAMay 15, 1971 · N5642W · Substantial damage NTSB NYC71FNA49Accident · No injuriesClosedPiper PA-23 · Stow, MAMay 11, 1971 · N3117P · Substantial damage NTSB NYC71AN108Accident · Minor injuriesClosedEnstrom F-28-A · Boston, MAMay 4, 1971 · N4923 · Destroyed NTSB NYC71FNE32Accident · No injuriesClosedPiper PA-18 · Hancock, MAMay 2, 1971 · N8697D · Substantial damage NTSB NYC71FNA47Accident · No injuriesClosedCessna 170B · Taunton, MAApr 17, 1971 · N2501D · Substantial damage NTSB NYC71FNA46Accident · No injuriesClosedPiper PA-23 · Norwood, MAApr 17, 1971 · N5376Y · Substantial damage NTSB NYC71DNA45Accident · No injuriesClosedChampion 7GCAA · Bedford, MAApr 15, 1971 · N1896G · Substantial damage NTSB NYC71IN101Incident · No injuriesClosedDouglas DC-8 · Boston, MAApr 13, 1971 · XASIA · Minor damage NTSB NYC71IN100Incident · No injuriesClosedDouglas DC-9 · Boston, MAApr 12, 1971 · N8922E · Minor damage NTSB NYC71DNA44Accident · No injuriesClosedAeronca L3B · Chatham, MAApr 10, 1971 · N46058 · Substantial damage NTSB NYC71DNA48Accident · No injuriesClosedPiper PA-28R · Bedford, MAApr 9, 1971 · N4599J · Substantial damage NTSB NYC71DNA42Accident · No injuriesClosedCessna 177 · Beverly, MAApr 4, 1971 · N2343Y · Substantial damage NTSB NYC71DFD40Accident · No injuriesClosedSlingsby T-53 · Norfolk, MAMar 27, 1971 · N1663 · Substantial damage NTSB NYC71DFD43Accident · No injuriesClosedCessna 150 · N Middleboro, MAMar 10, 1971 · N4679X · Substantial damage NTSB NYC71FFD39Accident · Minor injuriesClosedCessna 140 · Mrstns Mills, MAMar 2, 1971 · N76354 · Substantial damage NTSB NYC71FFD37Accident · No injuriesClosedPiper PA-23 · Shirley, MAFeb 6, 1971 · N4563P · Destroyed NTSB NYC71DFD34Accident · No injuriesClosedCessna 150 · Fall River, MAJan 23, 1971 · N3122J · Substantial damage NTSB NYC71DFD33Accident · No injuriesClosedPiper PA-28 · Mansfield, MAJan 20, 1971 · N5787U · Substantial damage NTSB NYC71DFD31Accident · No injuriesClosedCessna 150 · Franklin, MAJan 13, 1971 · N60460 · Substantial damage NTSB NYC71FFD32Accident · No injuriesClosedCessna 150K · Marlboro, MAJan 9, 1971 · N6346G · Substantial damage NTSB NYC71DFD36Accident · No injuriesClosedCessna 180 · Chatham, MAJan 7, 1971 · N481D · Substantial damage NTSB NYC71DFD30Accident · No injuriesClosedPiper PA-28 · Plymouth, MAJan 6, 1971 · N7249F · Substantial damage NTSB NYC71DFM25Accident · Minor injuriesClosedLuscombe 11A · G.Barrington, MADec 31, 1970 · N1686B · Substantial damage NTSB NYC71DFD27Accident · Minor injuriesClosedPiper PA-28 · Beverly, MADec 29, 1970 · N6720J · Substantial damage NTSB NYC71DFD26Accident · No injuriesClosedPiper PA-28 · Mansfield, MADec 29, 1970 · N8080N · Substantial damage NTSB NYC71DFD28Accident · No injuriesClosedThurston TSC-1A · Haverhill, MADec 27, 1970 · N2005T · Substantial damage NTSB NYC71FFD25Accident · No injuriesClosedCessna 180 · Bedford, MADec 20, 1970 · N3370D · Substantial damage