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 NYC76DNA16Accident · No injuriesClosedPiper PA-30 · Edgartown, MAJul 3, 1975 · N7260Y · Substantial damage NTSB NYC76AN001Accident · 1 fatalClosedPiper J3 · Stow, MAJul 3, 1975 · N2112M · Substantial damage NTSB NYC75FNE39Accident · Serious injuriesClosedSchweizer SGS233 · Sterling, MAJun 26, 1975 · N1222S · Substantial damage NTSB NYC75DNA48Accident · No injuriesClosedPiper PA-24 · Tewksbury, MAJun 24, 1975 · N5570P · Substantial damage NTSB NYC75FNA47Accident · No injuriesClosedPiper PA-28 · Bedford, MAJun 23, 1975 · N55498 · Substantial damage NTSB NYC75FNA46Accident · Serious injuriesClosedPiper PA-28 · Oak Bluffs, MAJun 22, 1975 · N9408T · Substantial damage NTSB NYC75FNE41Accident · No injuriesClosedBlanik L-13 · New Braintree, MAJun 21, 1975 · N2821H · Substantial damage NTSB NYC75AN119Accident · Minor injuriesClosedFairchild FH-227 · New Bedford, MAJun 13, 1975 · N378NE · Substantial damage NTSB NYC75AN116Accident · 1 fatalClosedN.American F-51D · Edgartown, MAJun 8, 1975 · N76AF · Destroyed NTSB NYC75AN110Accident · Minor injuriesClosedHughes 269B · Westfield, MAMay 28, 1975 · N103KC · Destroyed NTSB NYC7KFNA44Accident · Minor injuriesClosedHelio Acft H295 · Forge Village, MAMay 23, 1975 · N99PM · Substantial damage NTSB NYC75DNA41Accident · Minor injuriesClosedDehavilland DH 82A · Tewksbury, MAMay 23, 1975 · N8223 · Substantial damage NTSB NYC75DNA24Accident · No injuriesClosedCessna 210J · Marlborough, MAMay 23, 1975 · N3328S · Substantial damage NTSB NYC75FNA43Accident · No injuriesClosedFleet 2 · Norfolk, MAMay 22, 1975 · N1499T · Substantial damage NTSB NYC75FNA40Accident · No injuriesClosedSmith Mini · Hyannis, MAMay 22, 1975 · N18B · Substantial damage NTSB NYC75FNE37Accident · No injuriesClosedAeronca 7AC · Gardner, MAMay 18, 1975 · N85387 · Substantial damage NTSB NYC75FNE36Accident · No injuriesClosedTaylorcraft BC-65 · Fitchburg, MAMay 11, 1975 · N36195 · Substantial damage NTSB NYC75AN099Accident · Serious injuriesClosedRand KR-1 · Leominster, MAApr 16, 1975 · N8323 · Destroyed NTSB NYC75DNA39Accident · No injuriesClosedGrum Amer AA-5 · Tewksbury, MAApr 11, 1975 · N5414L · Substantial damage NTSB NYC75FNA38Accident · Serious injuriesClosedBeech J35 · Bedford, MAMar 29, 1975 · N303S · Destroyed NTSB NYC75FNA37Accident · No injuriesClosedCessna 195 · Hyannis, MAMar 24, 1975 · N9816A · Destroyed NTSB NYC75FNA36Accident · No injuriesClosedCessna 172 · Haverhill, MAMar 22, 1975 · N5480T · Substantial damage NTSB NYC75FNE31Accident · No injuriesClosedFunk B-85C · Westboro, MAMar 18, 1975 · N77703 · Substantial damage NTSB NYC75FNE30Accident · No injuriesClosedPiper PA-16 · E Brookfield, MAMar 16, 1975 · N5702H · Substantial damage NTSB NYC75FNA35Accident · No injuriesClosedBeech 95-58 · Plymouth, MAMar 5, 1975 · N678 · Substantial damage NTSB NYC75FNA34Accident · 1 fatalClosedCessna 182K · Canton, MAMar 2, 1975 · N2503Q · Destroyed NTSB NYC75DNA32Accident · No injuriesClosedCessna 172K · Hyannis, MAFeb 26, 1975 · N46422 · Substantial damage NTSB NYC75AN087Accident · No injuriesClosedBrittnorman BN-2A · Provincetown, MAFeb 23, 1975 · N90PB · Substantial damage NTSB NYC75AN086Accident · Serious injuriesClosedBeech 99 · Hyannis, MAFeb 23, 1975 · N7940 · Substantial damage NTSB NYC75FNE28Accident · No injuriesClosedCessna 150L · Worcester, MAFeb 20, 1975 · N10974 · Substantial damage NTSB NYC75FNA30Accident · Serious injuriesClosedBede BD5B · Littletown, MAFeb 10, 1975 · N746BD · Substantial damage NTSB NYC75AN081Accident · No injuriesClosedVolpar TC45J · Norwood, MAJan 20, 1975 · N10AS · Substantial damage NTSB NYC75FNE25Accident · No injuriesClosedCessna 170A · Orange, MAJan 19, 1975 · N5512C · Substantial damage NTSB NYC75DNA29Accident · No injuriesClosedCessna 182M · Stow, MAJan 4, 1975 · N91987 · Substantial damage NTSB NYC75FNE24Accident · Minor injuriesClosedAeronca 7AC · Turner Falls, MADec 31, 1974 · N85191 · Substantial damage NTSB NYC75FNE23Accident · Serious injuriesClosedCessna 150M · Southampton, MADec 31, 1974 · N66284 · Substantial damage NTSB NYC75FNA28Accident · No injuriesClosedPiper PA-28 · Norwood, MADec 26, 1974 · N635FL · Substantial damage NTSB NYC75ANA27Accident · Serious injuriesClosedChampion 7ECA · Hanson, MADec 11, 1974 · N5197T · Substantial damage NTSB NYC75FNA25Accident · No injuriesClosedCessna 150L · Millis, MANov 20, 1974 · N6635G · Substantial damage NTSB NYC75FNE19Accident · No injuriesClosedPiper PA-30 · Worcester, MANov 13, 1974 · N7283Y · Substantial damage NTSB NYC75IN057Incident · Minor injuriesClosedDouglas DC-9 · Boston, MANov 5, 1974 · N960VJ · Minor damage NTSB NYC75FNA24Accident · No injuriesClosedPiper PA-22 · Taunton, MAOct 28, 1974 · N57592 · Substantial damage NTSB NYC75FNE12Accident · No injuriesClosedCessna 172F · Bondsville, MAOct 27, 1974 · N855U · Substantial damage NTSB NYC75FNA22Accident · Serious injuriesClosedCessna 172C · Norwood, MAOct 20, 1974 · N2014Y · Substantial damage NTSB NYC75DNE16Accident · No injuriesClosedCessna 150 · Westboro, MAOct 15, 1974 · N7063S · Substantial damage NTSB NYC75FNA21Accident · No injuriesClosedChampion 7ECA · Marshfield, MAOct 14, 1974 · N1662G · Substantial damage NTSB NYC75FNA20Accident · Serious injuriesClosedPiper PA-24 · Haverhill, MAOct 4, 1974 · N8859P · Substantial damage NTSB NYC75FNA19Accident · No injuriesClosedEnstrom F-28A · Marshfied, MAOct 3, 1974 · N4879 · Substantial damage NTSB NYC75DNA17Accident · Minor injuriesClosedCessna 170B · Plymouth, MASep 19, 1974 · N2478D · Destroyed NTSB NYC75AN037Accident · Minor injuriesClosedCessna 421 · Westfield, MASep 13, 1974 · N3160K · Substantial damage