Skip to content

NTSB investigations, MA

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 NYC78DNA18Accident · No injuriesClosedCessna 150 · Newburyport, MAApr 22, 1978 · N7529G · Substantial damage NTSB NYC78DNA17Accident · No injuriesClosedPiper PA-28 · Beverly, MAApr 9, 1978 · N6413R · Substantial damage NTSB NYC78FNA15Accident · No injuriesClosedSchweizer SGS233 · Norfolk, MAApr 8, 1978 · N2480W · Substantial damage NTSB NYC78DNA16Accident · No injuriesClosedCessna 150 · Marlboro, MAMar 18, 1978 · N1283Q · Substantial damage NTSB NYC780NE14Accident · Minor injuriesClosedPiper J5B · Harvard, MAMar 11, 1978 · N38569 · Substantial damage NTSB NYC78FNE13Accident · No injuriesClosedCessna 150 · Sterling, MAMar 9, 1978 · N10877 · Substantial damage NTSB NYC78FNE12Accident · No injuriesClosedCessna 414 · Northampton, MAMar 3, 1978 · N7846Q · Substantial damage NTSB NYC78FNA13Accident · No injuriesClosedBeech P35 · Beverly, MAMar 3, 1978 · N1DL · Substantial damage NTSB NYC78FNA11Accident · No injuriesClosedPiper PA-28 · Haverhill, MAFeb 26, 1978 · N56725 · Substantial damage NTSB NYC78FNE11Accident · No injuriesClosedCessna 150 · Shrewsbury, MAFeb 25, 1978 · N7255G · Substantial damage NTSB NYC78DNC16Accident · No injuriesClosedCessna 182 · Bedford, MAFeb 22, 1978 · N19508 · Substantial damage NTSB NYC78FNE08Accident · No injuriesClosedChampion 7KCAB · Southbridge, MAFeb 13, 1978 · N9011L · Substantial damage NTSB NYC78FNA10Accident · No injuriesClosedEnstrom F-28A · Westwood, MAFeb 9, 1978 · N240Q · Substantial damage NTSB NYC78FNA08Accident · No injuriesClosedPiper PA-28 · Norwood, MAFeb 4, 1978 · N1036Q · Substantial damage NTSB NYC78FNA14Accident · No injuriesClosedPiper J3 · Haverhill, MAJan 29, 1978 · N5719N · Substantial damage NTSB NYC78DNA12Accident · No injuriesClosedCessna 172 · Falmouth, MAJan 28, 1978 · N2934U · Substantial damage NTSB NYC78FA017Accident · 2 fatalClosedHughes 269B · Quincy, MADec 27, 1977 · N9364F · Destroyed NTSB NYC78FNE01Accident · No injuriesClosedGrum Amer AA5-A · Sterling, MADec 24, 1977 · N9961U · Substantial damage NTSB NYC78FA011Accident · 1 fatalClosedCessna 206 · Taunton, MANov 30, 1977 · N2119F · Destroyed NTSB NYC78FA006Accident · 2 fatalClosedPorterfield 35W · Ft Devens, MANov 12, 1977 · N19448 · Destroyed NTSB NYC77FNA02Accident · No injuriesClosedPiper PA-30 · Plymouth, MAOct 31, 1977 · N7895Y · Substantial damage NTSB NYC78FNA04Accident · No injuriesClosedCessna 150 · Mansfield, MAOct 29, 1977 · N9470U · Substantial damage NTSB NYC78DNA01Accident · No injuriesClosedCessna 172 · Chatham, MAOct 5, 1977 · N76050 · Substantial damage NTSB NYC78DNA07Accident · No injuriesClosedCessna 182C · Pepperell, MAOct 2, 1977 · N8776T · Substantial damage NTSB NYC77FNA34Accident · No injuriesClosedCessna 182P · Mansfield, MASep 18, 1977 · N52793 · Substantial damage NTSB NYC77IA097Incident · No injuriesClosedMorane 235E · Plymouth, MASep 16, 1977 · F-ODFV · Minor damage NTSB NYC77FNA32Accident · No injuriesClosedAeronca 7AC · Stow, MASep 4, 1977 · N84453 · Substantial damage NTSB NYC77FNA31Accident · Serious injuriesClosedGrum Amer AA1B · Tewksbury, MAAug 29, 1977 · N8980L · Substantial damage NTSB NYC77FNE34Accident · Minor injuriesClosedNoorduyn UC64A · New Salem, MAAug 28, 1977 · N69795 · Destroyed NTSB NYC77FNA29Accident · No injuriesClosedPiper PA-28 · Chatham, MAAug 23, 1977 · N1526X · Substantial damage NTSB NYC77DNA33Accident · No injuriesClosedCitabria 7ECA · Race Point, MAAug 9, 1977 · N5171X · Destroyed NTSB NYC77FNE31Accident · Minor injuriesClosedCessna 150 · Hampden, MAJul 31, 1977 · N11109 · Substantial damage NTSB NYC77FNA25Accident · Serious injuriesClosedPiper PA-28 · Edgartown, MAJul 30, 1977 · N57363 · Substantial damage NTSB NYC77IA074Incident · Minor injuriesClosedDouglas DC-10 · Boston, MAJul 28, 1977 · N121AA · Minor damage NTSB NYC77FNA30Accident · No injuriesClosedStinson 108-3 · Marshfield, MAJul 27, 1977 · N584C · Substantial damage NTSB NYC77DNA24Accident · No injuriesClosedAero Comdr 100 · Hyannis, MAJul 26, 1977 · N2948T · Substantial damage NTSB NYC77DNA26Accident · No injuriesClosedBellanca 7GCBC · New Bedford, MAJul 16, 1977 · N53824 · Substantial damage NTSB NYC77FNA22Accident · No injuriesClosedPiper PA-18 · Oak Bluffs, MAJul 15, 1977 · N8975D · Destroyed NTSB NYC77DNA21Accident · No injuriesClosedCessna 310Q · Provincetown, MAJul 14, 1977 · N69684 · Destroyed NTSB NYC77FNE30Accident · No injuriesClosedPiper PA-32 · New Marlboroug, MAJul 11, 1977 · N3737W · Substantial damage NTSB NYC77FA070Accident · 3 fatalClosedPiper PA-28R · Hingham, MAJul 8, 1977 · N5275S · Destroyed NTSB NYC77FNA24Accident · No injuriesClosedCessna 310D · Norwood, MAJul 6, 1977 · N6758T · Substantial damage NTSB NYC77FNE25Accident · Minor injuriesClosedCessna 172 · Oxford, MAJun 28, 1977 · N79142 · Substantial damage NTSB NYC77FNE22Accident · 1 fatalClosedPiper PA-25 · Amherst, MAJun 20, 1977 · N6063Z · Destroyed NTSB NYC77FA064Accident · 2 fatalClosedErco 415C · New Bedford, MAJun 15, 1977 · N3762H · Destroyed NTSB NYC77FNA19Accident · Serious injuriesClosedCessna 207 · Vineyard Haven, MAJun 14, 1977 · N1718U · Substantial damage NTSB NYC77FA066Accident · 2 fatalClosedCessna 172K · Nantucket, MAJun 13, 1977 · N79005 · Destroyed NTSB NYC77FA063Accident · 1 fatalClosedBellanca 8KCAB · Haverhill, MAJun 7, 1977 · N86770 · Substantial damage NTSB NYC77DNA18Accident · No injuriesClosedCessna 206 · Boston, MAJun 3, 1977 · N4656Q · Substantial damage NTSB NYC77DNA17Accident · No injuriesClosedCessna 150 · Haverhill, MAMay 22, 1977 · N714SS · Substantial damage