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 NYC70IN129Incident · No injuriesClosedBoeing 707 · Nantucket, MAJun 9, 1970 · F-BNSF · No damage NTSB NYC70DFM15Accident · No injuriesClosedSchweizer SGS123 · Oakham, MAJun 8, 1970 · N91881 · Substantial damage NTSB NYC70FFD19Accident · No injuriesClosedChampion 7GCBC · Shirley, MAMay 29, 1970 · N5153X · Substantial damage NTSB NYC70FFD18Accident · No injuriesClosedPiper PA-18 · Chatham, MAMay 28, 1970 · N8105Y · Substantial damage NTSB NYC70FFD16Accident · No injuriesClosedPiper PA-24 · Chatham, MAMay 24, 1970 · N7825P · Substantial damage NTSB NYC70FFD15Accident · No injuriesClosedCessna 172F · Beverly, MAMay 16, 1970 · N8310U · Substantial damage NTSB NYC70DFD14Accident · No injuriesClosedBeech A-23 · Marlboro, MAMay 11, 1970 · N5957S · Substantial damage NTSB NYC70DFD13Accident · No injuriesClosedCessna 140 · Marlboro, MAMay 2, 1970 · N2002N · Substantial damage NTSB NYC70FFM12Accident · Minor injuriesClosedCessna 310N · Westfield, MAMay 1, 1970 · N4158Q · Destroyed NTSB NYC70AN116Accident · 3 fatalClosedPiper PA-32 · Stoughton, MAApr 24, 1970 · N3236W · Destroyed NTSB NYC70FFD10Accident · Minor injuriesClosedMooney M20E · Marlboro, MAApr 19, 1970 · N2612W · Substantial damage NTSB NYC70DFM11Accident · No injuriesClosedCessna 182 · Westboro, MAApr 14, 1970 · N9928T · Substantial damage NTSB NYC70FFM08Accident · Minor injuriesClosedPiper PA-16 · Pittsfield, MAMar 28, 1970 · N6847K · Substantial damage NTSB NYC70IN101Incident · 1 fatalClosedDouglas DC-9 · Boston, MAMar 17, 1970 · N8925E · No damage NTSB NYC70FFM07Accident · No injuriesClosedBrantly B-2 · Spencer, MAMar 14, 1970 · N5921X · Substantial damage NTSB NYC70DFD11Accident · No injuriesClosedBeech T-34 · Nantucket, MAMar 7, 1970 · N4113A · Substantial damage NTSB NYC70DFD09Accident · No injuriesClosedPiper PA-12 · Lawrence, MAMar 3, 1970 · N7708H · Substantial damage NTSB NYC70AN089Accident · 1 fatalClosedCessna 182 · Sterling, MAFeb 12, 1970 · N3339Y · Destroyed NTSB NYC70AN088Accident · 2 fatalClosedCessna 150 · Princeton, MAFeb 9, 1970 · N50873 · Destroyed NTSB NYC70IN080Incident · No injuriesClosedHam-Flugzeu HFA320 · Bedford, MAFeb 5, 1970 · N18RA · Minor damage NTSB NYC70FFD08Accident · Minor injuriesClosedPiper PA-28 · Bedford, MAFeb 5, 1970 · N8790N · Substantial damage NTSB NYC70FFM04Accident · No injuriesClosedAeronca 7AC · Turner Falls, MAFeb 1, 1970 · N85191 · Substantial damage NTSB NYC70FFM02Accident · Minor injuriesClosedBell 47G-2 · South Hadley, MAJan 31, 1970 · N1774 · Destroyed NTSB NYC70AN077Accident · No injuriesClosedPiper PA-31 · Bedford, MAJan 26, 1970 · N984MA · Substantial damage NTSB NYC70DFD06Accident · No injuriesClosedPiper PA-28 · Beverly, MAJan 24, 1970 · N6720J · Substantial damage NTSB NYC70FFD07Accident · Minor injuriesClosedPiper PA-23 · Mansfield, MAJan 22, 1970 · N4498P · Destroyed NTSB NYC70FFD04Accident · No injuriesClosedPiper PA-28 · Norwood, MAJan 20, 1970 · N98044 · Substantial damage NTSB NYC70DFD05Accident · No injuriesClosedCessna 150 · Marshfield, MAJan 16, 1970 · N6286S · Substantial damage NTSB NYC70FFM01Accident · No injuriesClosedBeech 35-C33 · Florida, MAJan 11, 1970 · N1941T · Substantial damage NTSB NYC70DFD03Accident · No injuriesClosedCessna 150 · Marshfield, MAJan 8, 1970 · N6618S · Substantial damage NTSB NYC70DIF03Accident · No injuriesClosedPiper PA-28 · Norwood, MAJan 5, 1970 · N98001 · Substantial damage NTSB NYC70DFD01Accident · No injuriesClosedCessna 170B · Tewksbury, MAJan 3, 1970 · N8202A · Substantial damage NTSB NYC70F0234Accident · No injuriesClosedAmer Avco AA-1 · Norwood, MADec 12, 1969 · N5620L · Substantial damage NTSB NYC70D0233Accident · No injuriesClosedBeech 35-C33 · East Boston, MANov 23, 1969 · N6037F · Substantial damage NTSB NYC70A0052Accident · No injuriesClosedPiper PA-28 · Norwood, MANov 18, 1969 · N5566F · 2 aircraft · Substantial damage NTSB NYC70F0195Accident · No injuriesClosedStinson 108-1 · Southwick, MAOct 19, 1969 · N97954 · Substantial damage NTSB NYC70A0043Accident · 1 fatalClosedPiper PA-28 · So.Weymouth, MAOct 13, 1969 · N6423W · Destroyed NTSB NYC70F0175Accident · No injuriesClosedCessna 150 · N Andover, MAOct 10, 1969 · N50157 · 2 aircraft · No damage NTSB NYC70D0196Accident · No injuriesClosedPiper PA-28 · Beverly, MASep 29, 1969 · N9901W · Substantial damage NTSB NYC70D0171Accident · No injuriesClosedBell 206A · Agawam, MASep 27, 1969 · N3523T · Substantial damage NTSB NYC70D0202Accident · No injuriesClosedPiper PA-28 · Fitchburg, MASep 21, 1969 · N292HA · 2 aircraft · Substantial damage NTSB NYC70D0159Accident · No injuriesClosedCessna 140 · Westboro, MASep 14, 1969 · N72366 · Substantial damage NTSB NYC70D0160Accident · No injuriesClosedPiper PA-23 · Tewksbury, MASep 11, 1969 · N428SF · Substantial damage NTSB NYC70A0032Accident · 1 fatalClosedPiper PA-28 · Sandisfield, MASep 7, 1969 · N1735J · Destroyed NTSB NYC70F0128Accident · No injuriesClosedCessna TU206U · Norwood, MAAug 26, 1969 · N734AP · Substantial damage NTSB NYC70F0134Accident · No injuriesClosedBell 47G · Worthington, MAAug 21, 1969 · N54047 · Substantial damage NTSB NYC70I0024Incident · No injuriesClosedBeech D18S · Boston, MAAug 19, 1969 · N722C · Minor damage NTSB NYC70F0106Accident · No injuriesClosedAmer Avco AA-1 · Norwood, MAAug 19, 1969 · N5747L · Destroyed NTSB NYC70D0102Accident · No injuriesClosedBeech T-34B · Orleans, MAAug 9, 1969 · N11SG · Substantial damage NTSB NYC70D0080Accident · No injuriesClosedAeronca 7KCAB · Hopedale, MAJul 31, 1969 · N5063X · Substantial damage