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 NYC74FNA31Accident · Serious injuriesClosedPiper J5A · Westford, MAJan 6, 1974 · N30313 · Substantial damage NTSB NYC74FNA30Accident · No injuriesClosedMcculloch J-2 · Taunton, MAJan 3, 1974 · N4343G · Substantial damage NTSB NYC74DNA29Accident · No injuriesClosedCessna 180 · Stow, MADec 23, 1973 · N1607C · Substantial damage NTSB DCA74AZ014Accident · Serious injuriesClosedDouglas DC-10 · Boston, MADec 17, 1973 · EC-CBN · Substantial damage NTSB NYC74FNA28Accident · No injuriesClosedCessna 150L · Lawrence, MADec 2, 1973 · N7529G · Substantial damage NTSB NYC74DNA27Accident · No injuriesClosedBeech 35C33A · Hyannis, MANov 22, 1973 · N7978M · Substantial damage NTSB NYC74AN043Accident · 4 fatalClosedCessna 402B · W Stockbrdge, MANov 16, 1973 · N50YL · Destroyed NTSB NYC74DNA25Accident · No injuriesClosedAmer Avco AA-1A · Bedford, MANov 13, 1973 · N9411L · Substantial damage NTSB NYC74DNA26Accident · Minor injuriesClosedPiper PA-22 · Stow, MANov 4, 1973 · N5269Z · Substantial damage NTSB DCA74AZ016Accident · 3 fatalClosedBoeing 707 · Boston, MANov 3, 1973 · N458PA · Destroyed NTSB NYC74FNA24Accident · No injuriesClosedLake LA-4 · Norwood, MAOct 27, 1973 · N7631L · Substantial damage NTSB NYC74DNA22Accident · No injuriesClosedCessna 177RG · Mansfield, MAOct 22, 1973 · N1991Q · Substantial damage NTSB NYC74AN033Accident · 3 fatalClosedPiper PA-23 · Spencer, MAOct 10, 1973 · N4745P · Destroyed NTSB NYC74DNA19Accident · No injuriesClosedBeech P35 · Plymouth, MAOct 6, 1973 · N1754G · Substantial damage NTSB NYC74DNA18Accident · Minor injuriesClosedChampion 7ECA · Malboro, MAOct 6, 1973 · N5116T · Destroyed NTSB NYC74DNA20Accident · No injuriesClosedPiper PA-28R · Marlboro, MASep 26, 1973 · N2279T · Substantial damage NTSB NYC74AN030Accident · 1 fatalClosedBeech 95-B55 · East Boston, MASep 23, 1973 · N8437N · Destroyed NTSB NYC74AN029Accident · 1 fatalClosedCessna 172K · Becket, MASep 22, 1973 · N78638 · Destroyed NTSB NYC74FNE07Accident · No injuriesClosedPiper PA-28 · Worcester, MASep 19, 1973 · N15531 · Substantial damage NTSB NYC74IN026Incident · No injuriesClosedLear 24 · Boston, MASep 18, 1973 · N7HA · Minor damage NTSB NYC74DNE06Accident · No injuriesClosedCessna 150 · Orange, MASep 16, 1973 · N18637 · Substantial damage NTSB NYC74DNA21Accident · No injuriesClosedChampion 7AC · Tewksbury, MASep 16, 1973 · N1816G · Substantial damage NTSB NYC74FNE04Accident · No injuriesClosedNoorduyn UC-64A · Orange, MASep 10, 1973 · N7990K · Substantial damage NTSB NYC74FNA16Accident · No injuriesClosedCessna 206 · East Boston, MASep 9, 1973 · N50463 · Substantial damage NTSB NYC74FNA17Accident · No injuriesClosedCessna 182 · Bedford, MASep 8, 1973 · N92153 · Substantial damage NTSB NYC74FNA15Accident · No injuriesClosedCessna 172L · Stow, MASep 7, 1973 · N6061Y · Substantial damage NTSB NYC74FNA14Accident · Minor injuriesClosedPiper PA-28 · Danvers, MASep 3, 1973 · N9572J · Substantial damage NTSB NYC74FNA12Accident · Minor injuriesClosedAmer Avco AA1-B · Tewksbury, MAAug 30, 1973 · N6273L · Substantial damage NTSB NYC74AN019Accident · 3 fatalClosedBeech 23 · Scituate, MAAug 30, 1973 · N7681R · Destroyed NTSB NYC74AN017Accident · 2 fatalClosedPiper PA-12 · Haverhill, MAAug 19, 1973 · N4192M · Destroyed NTSB NYC74FNE03Accident · No injuriesClosedCessna 150 · Westfield, MAAug 16, 1973 · N19488 · Substantial damage NTSB NYC74FNE02Accident · No injuriesClosedCessna 150F · Wendell, MAAug 13, 1973 · N8860G · Substantial damage NTSB NYC74FNA10Accident · No injuriesClosedLet Blanik L-13 · Pepperell, MAAug 4, 1973 · N93220 · Substantial damage NTSB NYC74FNA06Accident · Serious injuriesClosedPiper PA-28 · N.Andover, MAAug 4, 1973 · N15807 · Substantial damage NTSB NYC74FNA07Accident · No injuriesClosedPiper PA-24 · Vineyard Hav, MAJul 31, 1973 · N8659P · Substantial damage NTSB DCA74AZ004Accident · 88 fatalClosedDouglas DC-9 · Boston, MAJul 31, 1973 · N975NE · Destroyed NTSB NYC74DNA09Accident · No injuriesClosedBeech C18S · W.Falmouth, MAJul 30, 1973 · N44565 · Destroyed NTSB NYC74FNA05Accident · No injuriesClosedPiper PA-32 · Plymouth, MAJul 24, 1973 · N4213R · Substantial damage NTSB NYC74AN005Accident · 1 fatalClosedPiper PA-28 · Martha Vinyd, MAJul 10, 1973 · N2679T · Substantial damage NTSB NYC74FNA02Accident · No injuriesClosedPiper PA-24 · Chatham, MAJul 7, 1973 · N7462P · Substantial damage NTSB NYC74FNA01Accident · No injuriesClosedCessna 177RG · New Bedford, MAJul 7, 1973 · N1945Q · Substantial damage NTSB NYC74AN004Accident · 5 fatalClosedCessna 172L · Douglas, MAJul 1, 1973 · N19663 · Substantial damage NTSB NYC73FNA53Accident · No injuriesClosedBeech B23 · Danvers, MAJun 28, 1973 · N7617R · Substantial damage NTSB NYC73FNE36Accident · No injuriesClosedCessna 310Q · Westfield, MAJun 26, 1973 · N7667Q · Substantial damage NTSB NYC73FNE35Accident · No injuriesClosedViking B-8 · Westboro, MAJun 24, 1973 · N753Y · Substantial damage NTSB NYC73AN152Accident · No injuriesClosedDouglas DC-8 · Boston, MAJun 15, 1973 · HP-IDK · Substantial damage NTSB NYC73FNA52Accident · No injuriesClosedCessna 195B · Chatham, MAJun 14, 1973 · N2109C · Substantial damage NTSB NYC74FNA04Accident · No injuriesClosedBensen B8M · Plymouth, MAJun 3, 1973 · N6026 · Substantial damage NTSB NYC73AN148Accident · 2 fatalClosedBeech D18S · Feeding Hill, MAJun 2, 1973 · N8615A · Destroyed NTSB NYC73FNA50Accident · No injuriesClosedCessna 310C · Hyannis, MAMay 30, 1973 · N6727T · Substantial damage