Skip to content

NTSB investigations, MA

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 NYC66D0471Accident · No injuriesClosedCessna 182 · Marlboro, MAFeb 12, 1966 · N6065B · Substantial damage NTSB NYC66F0518Accident · No injuriesClosedPiper JC3 · Lawrence, MAFeb 6, 1966 · N6340H · Substantial damage NTSB NYC66F0465Accident · No injuriesClosedPiper PA-28 · Norwood, MAJan 29, 1966 · N6712W · Substantial damage NTSB NYC66A0073Accident · No injuriesClosedBell 47J-2 · East Boston, MAJan 14, 1966 · N8433E · Substantial damage NTSB NYC66F0431Accident · No injuriesClosedBeechcraft F35 · Bedford, MAJan 13, 1966 · N5060B · Substantial damage NTSB NYC66A0071Accident · 1 fatalClosedStinson L-5 · Norfolk, MAJan 9, 1966 · N1314V · Destroyed NTSB NYC66F0449Accident · Minor injuriesClosedCessna 150F · Mansfield, MAJan 5, 1966 · N8948S · Substantial damage NTSB NYC66F0411Accident · No injuriesClosedCessna 140A · Marlboro, MAJan 1, 1966 · N5675C · Substantial damage NTSB NYC66D0418Accident · No injuriesClosedCessna 172C · Tauton, MAJan 1, 1966 · N1835Y · Substantial damage NTSB NYC66D0416Accident · No injuriesClosedBeechcraft G35 · Mendon, MADec 31, 1965 · N4409D · Destroyed NTSB NYC66F0435Accident · No injuriesClosedErcoupe 415-D · Marlboro, MADec 30, 1965 · N1DA · Substantial damage NTSB NYC66D0414Accident · No injuriesClosedCessna 140 · Tewksbury, MADec 19, 1965 · N3083N · Substantial damage NTSB NYC66F0430Accident · Minor injuriesClosedPiper JC3-65 · Pepperell, MADec 18, 1965 · N33121 · Substantial damage NTSB NYC66F0389Accident · Minor injuriesClosedPiper PA-28 · Worcester, MADec 7, 1965 · N6596W · Substantial damage NTSB NYC66D0377Accident · No injuriesClosedCessna 180 · Rochester, MADec 4, 1965 · N9186T · Substantial damage NTSB NYC66D0406Accident · No injuriesClosedCessna 337 · Beverly, MADec 2, 1965 · N2225X · Substantial damage NTSB NYC66D0358Accident · No injuriesClosedCessna 150 · Falmouth, MANov 21, 1965 · N7728E · Substantial damage NTSB NYC66I0057Incident · No injuriesClosedBoeing 707 321B · Boston, MANov 20, 1965 · N798PA · No damage NTSB NYC66F0365Accident · No injuriesClosedPiper J3C-65 · Agawam, MANov 12, 1965 · N70596 · Substantial damage NTSB NYC66F0327Accident · No injuriesClosedPiper PA-28 · Brookfield, MANov 3, 1965 · N6235W · Substantial damage NTSB NYC66F0343Accident · Minor injuriesClosedPiper PA-28 · Lynn, MAOct 31, 1965 · N5373W · Substantial damage NTSB NYC66F0309Accident · No injuriesClosedPiper PA-22 · Northampton, MAOct 31, 1965 · N830MD · Substantial damage NTSB NYC66I0049Incident · No injuriesClosedDouglas DC-6 · Boston, MAOct 17, 1965 · N90748 · No damage NTSB NYC66F0293Accident · No injuriesClosedStinson 108-1 · Westfield, MAOct 8, 1965 · N97376 · Substantial damage NTSB NYC66F0274Accident · No injuriesClosedBeechcraft E50 · Hopedale, MASep 25, 1965 · N4395D · Substantial damage NTSB NYC66F0267Accident · No injuriesClosedCessna 150 · Beverly, MASep 22, 1965 · N7884E · Substantial damage NTSB NYC66F0219Accident · No injuriesClosedPiper PA-22 · Norwood, MASep 12, 1965 · N5959Z · Substantial damage NTSB NYC66F0210Accident · No injuriesClosedErcoupe 415C · Agawam, MASep 7, 1965 · N93674 · Substantial damage NTSB NYC66F0222Accident · No injuriesClosedCessna 170B · Norwood, MASep 4, 1965 · N2438D · Substantial damage NTSB NYC66F0220Accident · No injuriesClosedPiper PA-28 · Gr Barringtn, MASep 3, 1965 · N6586W · Substantial damage NTSB NYC66F0226Accident · No injuriesClosedPiper PA-28 · Lawrence, MAAug 31, 1965 · N5647W · Substantial damage NTSB NYC66F0168Accident · Minor injuriesClosedPiper J5A · Gardner, MAAug 25, 1965 · N40980 · Substantial damage NTSB NYC66D0167Accident · No injuriesClosedPiper PA-22 · Marlboro, MAAug 22, 1965 · N5674Z · Substantial damage NTSB NYC66F0189Accident · No injuriesClosedPiper PA-24 · Newburyport, MAAug 16, 1965 · N5034P · Substantial damage NTSB NYC66A0022Accident · No injuriesClosedDouglas DC-6A · Boston, MAAug 15, 1965 · N37595 · Substantial damage NTSB NYC66A0021Accident · 3 fatalClosedAeronca 15AC · Mashpee, MAAug 14, 1965 · N1375H · Destroyed NTSB NYC66F0183Accident · No injuriesClosedAeronca 11AC · Tewksbury, MAAug 11, 1965 · N3199E · Substantial damage NTSB NYC66F0175Accident · No injuriesClosedBeechcraft T-34A · Turner Falls, MAAug 11, 1965 · N8701R · Substantial damage NTSB NYC66F0158Accident · Serious injuriesClosedPiper PA-15 · Lowell, MAAug 10, 1965 · N4392H · Destroyed NTSB NYC66F0190Accident · No injuriesClosedBeechcraft C-45H · Nantucket, MAAug 8, 1965 · N160L · Substantial damage NTSB NYC66F0154Accident · Minor injuriesClosedPiper PA-28 · Lenox, MAAug 6, 1965 · N9029W · Substantial damage NTSB NYC66F0122Accident · Minor injuriesClosedChampion 7ECA · Norfolk, MAAug 1, 1965 · N2572F · Substantial damage NTSB NYC66D0145Accident · No injuriesClosedPiper J-3 · Cheshire, MAJul 31, 1965 · N42165 · Substantial damage NTSB NYC66D0130Accident · No injuriesClosedScheibe L-SPAT · Heath, MAJul 30, 1965 · N8752R · Substantial damage NTSB NYC66F0124Accident · No injuriesClosedPiper PA-18A · Southwick, MAJul 29, 1965 · N3707A · Substantial damage NTSB NYC66F0119Accident · 1 fatalClosedScheibe L-55 · New Braintre, MAJul 26, 1965 · N10110 · Destroyed NTSB NYC66D0135Accident · No injuriesClosedPiper PA-28 · Newburyport, MAJul 26, 1965 · N6084W · Substantial damage NTSB NYC66F0100Accident · No injuriesClosedPiper PA-28 · Taunton, MAJul 23, 1965 · N6510W · Substantial damage NTSB NYC66F0099Accident · No injuriesClosedLockheed 10A · East Boston, MAJul 19, 1965 · N38PB · Substantial damage NTSB NYC66D0055Accident · Minor injuriesClosedPiper PA-22 · Palmer, MAJul 13, 1965 · N7341D · Substantial damage