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 NYC73DNA06Accident · No injuriesClosedAmer Avco AA1 · Mansfield, MAJul 28, 1972 · N9382L · Substantial damage NTSB NYC73FNA07Accident · No injuriesClosedCessna 150L · Chatham, MAJul 24, 1972 · N16007 · Substantial damage NTSB NYC73FNE03Accident · Minor injuriesClosedCessna 172E · Sterling, MAJul 14, 1972 · N3689S · Destroyed NTSB NYC73FNA03Accident · No injuriesClosedPiper J3C-65 · Halifax, MAJul 8, 1972 · N42186 · Substantial damage NTSB NYC72FNA02Accident · No injuriesClosedBoeing A75 · Wareham, MAJul 7, 1972 · N1419M · Substantial damage NTSB NYC73FNA01Accident · No injuriesClosedCessna 182B · Concord, MAJul 5, 1972 · N2524G · Substantial damage NTSB NYC73IN002Incident · No injuriesClosedDouglas DC-8 · Ea.Boston, MAJul 2, 1972 · HB-IDG · Minor damage NTSB NYC73FNE02Accident · Minor injuriesClosedPiper PA-28 · Fitchburg, MAJul 2, 1972 · N601FL · Substantial damage NTSB NYC73DNA05Accident · No injuriesClosedCessna 150J · Groton, MAJul 2, 1972 · N5549G · Substantial damage NTSB NYC72DNA48Accident · Minor injuriesClosedPiper PA-12 · Falmouth, MAJun 26, 1972 · N2468M · Substantial damage NTSB NYC72DNA47Accident · Minor injuriesClosedAeronca 7BCM · Norfolk, MAJun 24, 1972 · N1965E · Substantial damage NTSB NYC72FNA45Accident · No injuriesClosedPiper PA-24 · Hopedale, MAJun 17, 1972 · N7825P · Substantial damage NTSB NYC72FNA43Accident · Minor injuriesClosedCessna 180 · Concord, MAJun 11, 1972 · N1798C · Substantial damage NTSB NYC72FNA42Accident · No injuriesClosedPiper PA-24 · Hopedale, MAJun 11, 1972 · N1Q · Substantial damage NTSB NYC72FNA44Accident · No injuriesClosedLuscombe 8A · Marshfield, MAJun 2, 1972 · N71827 · Substantial damage NTSB NYC72IN145Incident · No injuriesClosedBoeing 747 · Boston, MAMay 24, 1972 · N743PA · Minor damage NTSB NYC72FNA41Accident · Serious injuriesClosedBell 47D · Accord, MAMay 12, 1972 · N177B · Destroyed NTSB NYC72FNA38Accident · No injuriesClosedPiper PA-28R · Plymouth, MAApr 29, 1972 · N7530J · Substantial damage NTSB NYC72FNA39Accident · No injuriesClosedPiper PA-28 · Brockton, MAApr 24, 1972 · N5396S · Substantial damage NTSB NYC72AN122Accident · 1 fatalClosedPiper PA-23 · Acton, MAApr 6, 1972 · N6342L · Destroyed NTSB NYC72DNE33Accident · No injuriesClosedPiper PA-28 · Westboro, MAApr 1, 1972 · N696FL · Substantial damage NTSB NYC72FNA37Accident · Serious injuriesClosedPiper PA-24 · Marshfield, MAMar 11, 1972 · N6322P · Substantial damage NTSB NYC72FNE30Accident · No injuriesClosedCessna 150H · Sterling, MAMar 9, 1972 · N6455S · Substantial damage NTSB NYC72AN104Accident · 2 fatalClosedCessna 421B · East Boston, MAMar 2, 1972 · N456CB · Destroyed NTSB NYC72AN103Accident · No injuriesClosedDassault Falcon · Boston, MAFeb 28, 1972 · N30JM · Substantial damage NTSB NYC22DNA36Accident · No injuriesClosedCessna 150 · Marlboro, MAFeb 23, 1972 · N22849 · Substantial damage NTSB NYC72AN099Accident · No injuriesClosedBeech G18S · Boston, MAFeb 20, 1972 · N1125M · Substantial damage NTSB NYC72FNA33Accident · No injuriesClosedPiper PA-24 · Norwood, MAFeb 15, 1972 · N7453P · Substantial damage NTSB NYC72DNA30Accident · No injuriesClosedCessna 172 · East Boston, MAJan 25, 1972 · N6618A · Substantial damage NTSB NYC72FNA29Accident · No injuriesClosedBeech 56TC · Norwood, MAJan 21, 1972 · N5463U · Substantial damage NTSB NYC72FNA24Accident · Serious injuriesClosedAmer Avco AA5 · Tewksbury, MAJan 2, 1972 · N5803L · Destroyed NTSB NYC72FNE21Accident · No injuriesClosedCessna 150 · Turnrs Falls, MAJan 1, 1972 · N100FA · Substantial damage NTSB NYC72FNA25Accident · No injuriesClosedPiper PA-24 · Newburyport, MADec 31, 1971 · N8865P · Substantial damage NTSB NYC72FNA27Accident · No injuriesClosedCessna 172 · Plymouth, MADec 19, 1971 · N46601 · Substantial damage NTSB NYC72FNE18Accident · Serious injuriesClosedCessna 150J · Goshen, MADec 12, 1971 · N61180 · Substantial damage NTSB NYC72FNA22Accident · No injuriesClosedBeech J35 · Bedford, MADec 4, 1971 · N636Q · Substantial damage NTSB NYC72AN073Accident · 5 fatalClosedPiper PA-32 · Adams, MANov 28, 1971 · N550XX · Destroyed NTSB NYC72DNA21Accident · No injuriesClosedPiper PA-28 · Edgartown, MANov 20, 1971 · N3488K · Substantial damage NTSB NYC72FNA20Accident · 1 fatalClosedPiper J3C-65 · Haverhill, MANov 13, 1971 · N3406K · Destroyed NTSB NYC72FNA18Accident · No injuriesClosedPiper PA-28 · Norwood, MANov 10, 1971 · N5339S · Substantial damage NTSB NYC72FNA17Accident · No injuriesClosedAir & Space 18A · Bedford, MANov 3, 1971 · N6159S · Destroyed NTSB NYC72FNA16Accident · No injuriesClosedCessna A150K · Mansfield, MAOct 29, 1971 · N5907J · Substantial damage NTSB NYC72FNA15Accident · No injuriesClosedAmer Avco AA1 · Tewksbury, MAOct 27, 1971 · N5611L · Substantial damage NTSB NYC72FNA14Accident · Serious injuriesClosedSikorsky S-55 · Acton, MAOct 15, 1971 · N9009R · Destroyed NTSB NYC72FNE14Accident · Serious injuriesClosedCessna 172H · Agawam, MAOct 14, 1971 · N2463L · Destroyed NTSB NYC72AN052Accident · No injuriesClosedPiper PA-32 · Fitchburg, MASep 9, 1971 · N294HA · 2 aircraft · Minor damage NTSB NYC72AN034Accident · 2 fatalClosedCessna 172K · Plymouth, MASep 6, 1971 · N79205 · Destroyed NTSB NYC72FNA11Accident · No injuriesClosedBeech V35A · Nantucket, MASep 2, 1971 · N7125N · Substantial damage NTSB NYC72FNA10Accident · No injuriesClosedBell 47G-4A · Norwood, MASep 2, 1971 · N4012G · Substantial damage NTSB NYC72FNA09Accident · Minor injuriesClosedCessna 150K · Mansfield, MAAug 22, 1971 · N5792G · Substantial damage