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 NYC67D0217Accident · No injuriesClosedHoward DGA-15 · Turner Falls, MAAug 27, 1966 · N63427 · Substantial damage NTSB NYC67D0154Accident · No injuriesClosedCessna 170B · Plymouth, MAAug 20, 1966 · N3123A · Substantial damage NTSB NYC67A0030Accident · No injuriesClosedBell 47J-2 · Dedham, MAAug 17, 1966 · N3939B · Substantial damage NTSB NYC67D0098Accident · No injuriesClosedPiper PA-24 · Norwood, MAAug 1, 1966 · N8291P · Substantial damage NTSB NYC67D0128Accident · Minor injuriesClosedPiper J3C-65 · Cheshire, MAJul 31, 1966 · N88179 · Substantial damage NTSB NYC67D0135Accident · No injuriesClosedPiper PA-23 · Hyannis, MAJul 26, 1966 · N4330Y · Substantial damage NTSB NYC67F0119Accident · No injuriesClosedPiper PA-25 · Worthington, MAJul 18, 1966 · N6174Z · Substantial damage NTSB NYC67D0079Accident · No injuriesClosedLuscombe 8A · Marlboro, MAJul 17, 1966 · N25237 · Substantial damage NTSB NYC67A0015Accident · 1 fatalClosedPiper PA-22 · E Taunton, MAJul 16, 1966 · N5638Z · Destroyed NTSB NYC67D0076Accident · No injuriesClosedPiper PA-28 · Hopedale, MAJul 15, 1966 · N5716W · Substantial damage NTSB NYC67F0125Accident · No injuriesClosedPiper PA-28 · Norwood, MAJul 11, 1966 · N8841W · Substantial damage NTSB NYC67D0097Accident · No injuriesClosedCessna 150 · Danvers, MAJul 9, 1966 · N6562F · Substantial damage NTSB NYC67A0006Accident · Minor injuriesClosedBell 47G · W.Barnstable, MAJul 8, 1966 · N932B · Substantial damage NTSB NYC67D0016Accident · No injuriesClosedPiper PA-23 · Norwood, MAJul 4, 1966 · N4455P · Substantial damage NTSB NYC67D0299Accident · No injuriesClosedCessna 182C · Hyannis, MAJul 2, 1966 · N8877T · Substantial damage NTSB NYC67F0017Accident · No injuriesClosedCessna 140 · Fitchburg, MAJun 30, 1966 · N4194N · Substantial damage NTSB NYC67F0075Accident · No injuriesClosedCessna 210 · Gardner, MAJun 29, 1966 · N9635T · Substantial damage NTSB NYC67F0062Accident · No injuriesClosedPiper PA-24 · Bedford, MAJun 27, 1966 · N8385P · Substantial damage NTSB NYC66A0160Accident · No injuriesClosedAero Comdr 500 · East Boston, MAJun 26, 1966 · N6249B · Substantial damage NTSB NYC66A0158Accident · 6 fatalClosedBeech S35 · Hyannis, MAJun 26, 1966 · N8838M · Destroyed NTSB NYC67D0029Accident · No injuriesClosedCessna 175 · East Boston, MAJun 23, 1966 · N6574E · Substantial damage NTSB NYC67D0331Accident · No injuriesClosedPiper PA-22 · Oak Bluffs, MAJun 21, 1966 · N2567A · Substantial damage NTSB NYC66A0152Accident · No injuriesClosedBell 47J-2 · Burlington, MAJun 18, 1966 · N73948 · Substantial damage NTSB NYC67F0123Accident · No injuriesClosedBeech 95-B55 · Beverly, MAJun 15, 1966 · N781K · Substantial damage NTSB NYC67D0166Accident · No injuriesClosedPiper PA-16 · Newburyport, MAJun 15, 1966 · N5651H · Substantial damage NTSB NYC67D0018Accident · No injuriesClosedCessna 150 · N. Andover, MAJun 12, 1966 · N3590L · Substantial damage NTSB NYC66I0145Incident · No injuriesClosedBoeing 707 322 · Boston, MAJun 7, 1966 · N723PA · Minor damage NTSB NYC67F0031Accident · Minor injuriesClosedCessna 140 · Norwood, MAJun 2, 1966 · N2451V · Substantial damage NTSB NYC67F0015Accident · Minor injuriesClosedPiper J3 · Tewksbury, MAMay 30, 1966 · N7485H · Destroyed NTSB NYC66I0136Incident · No injuriesClosedPiper PA-30 · E.Boston, MAMay 26, 1966 · N8014Y · 2 aircraft · Minor damage NTSB NYC66A0135Accident · No injuriesClosedBell 47J-2 · Burlington, MAMay 23, 1966 · N8499E · Substantial damage NTSB NYC66I0142Incident · No injuriesClosedBoeing 727 · East Boston, MAMay 20, 1966 · N8145N · No damage NTSB NYC66F0704Accident · Minor injuriesClosedPiper PA-22 · Tewksbury, MAApr 30, 1966 · N8862D · Substantial damage NTSB NYC66F0640Accident · Serious injuriesClosedLuscombe T-8F · Charlemont, MAApr 22, 1966 · N2168B · Destroyed NTSB NYC66F0636Accident · No injuriesClosedCessna 150 · Bedford, MAApr 17, 1966 · N8171S · Substantial damage NTSB NYC66D0631Accident · No injuriesClosedGlobe GC-1B · Orange, MAApr 17, 1966 · N3785K · Substantial damage NTSB NYC66F0627Accident · No injuriesClosedBellanca 14-19 · Palmer, MAApr 15, 1966 · N7697B · Substantial damage NTSB NYC66A0114Accident · Serious injuriesClosedPiper PA-28 · Becket, MAApr 10, 1966 · N7800W · Destroyed NTSB NYC66F0593Accident · Minor injuriesClosedCessna 172F · Haverhill, MAMar 30, 1966 · N8556U · Substantial damage NTSB NYC66F0597Accident · No injuriesClosedPiper PA-22 · Sterling, MAMar 26, 1966 · N9638D · Substantial damage NTSB NYC66F0569Accident · No injuriesClosedPiper J-3 · Tewksbury, MAMar 19, 1966 · N7485H · Substantial damage NTSB NYC66A0100Accident · 2 fatalClosedCessna 150 · Waltham, MAMar 16, 1966 · N2063Z · Destroyed NTSB NYC66I0098Incident · No injuriesClosedBoeing B-727 · Boston, MAMar 15, 1966 · N8015N · No damage NTSB NYC66F0553Accident · No injuriesClosedPiper PA-28 · Beverly, MAMar 3, 1966 · N6098W · Substantial damage NTSB NYC66F0552Accident · No injuriesClosedPiper PA-28 · Beverly, MAMar 3, 1966 · N6526W · Substantial damage NTSB NYC66A0097Accident · No injuriesClosedCessna 172C · East Boston, MAMar 2, 1966 · N1486Y · Substantial damage NTSB NYC66F0496Accident · No injuriesClosedPiper PA-23 · Northampton, MAFeb 24, 1966 · N1228P · Substantial damage NTSB NYC66F0644Accident · No injuriesClosedCessna 150 · Bedford, MAFeb 22, 1966 · N8366G · Substantial damage NTSB NYC66F0558Accident · Minor injuriesClosedStinson 108-1 · Shirley, MAFeb 20, 1966 · N8314K · Substantial damage NTSB NYC66F0516Accident · No injuriesClosedCessna 150E · Mansfield, MAFeb 15, 1966 · N3501J · Substantial damage