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 NYC80DA058Accident · No injuriesClosedVarga 2150A · Marlboro, MAJul 16, 1980 · N8419J · Substantial damage NTSB NYC80DNA16Accident · No injuriesClosedPiper PA-28 · Oak Bluffs, MAJul 12, 1980 · N9858W · Substantial damage NTSB MKC80IA052Incident · No injuriesClosedBeech 99 · Boston, MAJul 8, 1980 · N100WP · Minor damage NTSB NYC80FNA15Accident · No injuriesClosedPiper PA-23 · Norwood, MAJun 23, 1980 · N129RM · Substantial damage NTSB NYC80FNE18Accident · Serious injuriesClosedCessna 172M · Worcester, MAJun 14, 1980 · N64238 · Destroyed NTSB NYC80FA045Accident · 4 fatalClosedCessna 210E · Provincetown, MAJun 14, 1980 · N4919U · Destroyed NTSB NYC80DNA13Accident · No injuriesClosedCessna 305A · Plymouth, MAJun 13, 1980 · N22SU · Substantial damage NTSB NYC80FNE17Accident · No injuriesClosedPiper PA-28 · Hampden, MAMay 28, 1980 · N21480 · Substantial damage NTSB NYC80FNA12Accident · No injuriesClosedBell 47G · Middleborough, MAMay 28, 1980 · N2277W · Substantial damage NTSB NYC80FA065Accident · No injuriesClosedVarga 2150A · Marlboro, MAMay 26, 1980 · N8419J · Substantial damage NTSB NYC80FNE14Accident · Serious injuriesClosedSchemp STD-CR · North Adams, MAMay 4, 1980 · N15WB · Substantial damage NTSB NYC80FNA10Accident · Minor injuriesClosedBell 47G-3B · Plymouth, MAMar 20, 1980 · N7943J · Substantial damage NTSB NYC80DNA11Accident · No injuriesClosedCessna 152 · Plymouth, MAMar 19, 1980 · N25589 · Substantial damage NTSB NYC80FNE12Accident · No injuriesClosedCessna 150 · Hardwick, MAMar 17, 1980 · N9283U · Substantial damage NTSB NYC80FNA06Accident · Minor injuriesClosedCessna 177RG · Mashpee, MADec 18, 1979 · N35106 · Substantial damage NTSB NYC80FNE06Accident · No injuriesClosedPiper PA-28 · Westfield, MADec 15, 1979 · N4525F · No damage NTSB NYC80DNA05Accident · No injuriesClosedCessna 172K · Bedford, MADec 8, 1979 · N79883 · Substantial damage NTSB NYC80FNA04Accident · Minor injuriesClosedCessna 182P · Marlboro, MANov 4, 1979 · N5639J · Substantial damage NTSB NYC80FA008Accident · 1 fatalClosedCessna 152 · New Bedford, MAOct 31, 1979 · N757ZW · Destroyed NTSB UNK80X0101Accident · 1 fatalClosedNavion G · Concord, MAOct 28, 1979 · N2412T · Destroyed NTSB NYC80FNE01Accident · Minor injuriesClosedPiper PA-32S · W.Springfield, MAOct 20, 1979 · N5223S · Substantial damage NTSB NYC80FNA02Accident · No injuriesClosedCessna 150H · Norton, MAOct 19, 1979 · N7001S · Substantial damage NTSB NYC80FNA01Accident · No injuriesClosedCessna 172E · So.Weymouth, MAOct 11, 1979 · N15138 · Substantial damage NTSB NYC79FNA30Accident · No injuriesClosedPiper PA-28 · Marlboro, MASep 26, 1979 · N29010 · Substantial damage NTSB NYC79AA106Accident · Minor injuriesClosedMcdonnell Douglas DC9 · Boston, MAa fatigue fracture of the aft cabin pressure bulkhead which resulted in a rapid decompression of the aircraft's cabin area. This fracture initiated from a crack below the aft bulkhead access door which was discernible on the X-rays taken during the aircraft's…Sep 17, 1979 · CF-TLU · Substantial damage NTSB NYC79FNE20Accident · 1 fatalClosedPiper PA-25 · Lee, MASep 5, 1979 · N6505Z · Destroyed NTSB NYC79FNA31Accident · No injuriesClosedCessna 150L · Tewksbury, MAAug 31, 1979 · N18585 · Substantial damage NTSB NYC79FNA29Accident · No injuriesClosedCessna 172N · Newburyport, MAAug 26, 1979 · N734QZ · Substantial damage NTSB NYC79FNA28Accident · No injuriesClosedBellanca 8GCBC · Plymouth, MAAug 18, 1979 · N50548 · Substantial damage NTSB NYC79DA077Accident · No injuriesClosedPiper PA-18 · Chatam, MAAug 15, 1979 · N8478Y · Destroyed NTSB NYC79FNA26Accident · No injuriesClosedCessna 150 · North Andover, MAJul 30, 1979 · N10796 · Substantial damage NTSB NYC79FNA24Accident · No injuriesClosedCessna 305A · Quincy, MAJul 21, 1979 · N5284G · Substantial damage NTSB NYC79DA060Accident · No injuriesClosedCessna 402 · Nantucket, MAJul 19, 1979 · N5419M · Substantial damage NTSB NYC79FNA21Accident · No injuriesClosedCessna 150M · Middleboro, MAJul 10, 1979 · N66349 · Substantial damage NTSB NYC79FNA20Accident · Minor injuriesClosedPiper PA-24 · Marshfield, MAJul 8, 1979 · N9041P · Substantial damage NTSB NYC79FNA19Accident · No injuriesClosedCiciora T-18 · West Tisbury, MAJul 4, 1979 · N64628 · Substantial damage NTSB NYC79DNA18Accident · No injuriesClosedPiper PA-22 · Boston, MAJun 27, 1979 · N733AP · Substantial damage NTSB DCA79AA019Accident · 1 fatalClosedDehavilland DHC-6 · Hyannis, MAJun 17, 1979 · N383EX · Destroyed NTSB NYC79FNA17Accident · Minor injuriesClosedStarduster SA-300 · Boxboro, MAJun 7, 1979 · N33MH · Substantial damage NTSB NYC79FNA16Accident · No injuriesClosedMiniplane DSA-1 · Boxboro, MAJun 3, 1979 · N13G · Substantial damage NTSB NYC79DNA15Accident · No injuriesClosedCessna 172 · Marlboro, MAApr 11, 1979 · N5451H · Substantial damage NTSB NYC79FNE12Accident · No injuriesClosedPiper PA-28 · Chicopee, MAMar 17, 1979 · N2163T · Substantial damage NTSB NYC79FNE08Accident · No injuriesClosedDuster BJ-1B · North Adams, MAFeb 17, 1979 · N12GT · Substantial damage NTSB NYC79FNA13Accident · No injuriesClosedCessna 500 · Boston, MAFeb 7, 1979 · N186MW · Substantial damage NTSB NYC79FNA12Accident · No injuriesClosedCessna 172 · Boston, MAJan 29, 1979 · N9701T · Substantial damage NTSB NYC79FNA11Accident · Minor injuriesClosedCessna 172 · Lawrence, MAJan 17, 1979 · N8958V · Substantial damage NTSB NYC79FA017Accident · 5 fatalClosedPiper PA-31 · Templeton, MAJan 11, 1979 · N33TN · 2 aircraft · Destroyed NTSB NYC79FNE05Accident · No injuriesClosedCessna 150 · Hardwick, MAJan 6, 1979 · N1153Y · Substantial damage NTSB NYC79FNA10Accident · No injuriesClosedCessna 172 · Boston, MADec 25, 1978 · N12083 · Substantial damage NTSB NYC79FNE03Accident · No injuriesClosedCessna 150 · Gardner, MADec 23, 1978 · N22785 · Substantial damage