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 NYC70D0079Accident · No injuriesClosedAeronca 11BC · Hopedale, MAJul 31, 1969 · N85817 · Substantial damage NTSB NYC70D0105Accident · No injuriesClosedGlobe Swift GC-1B · Fitchburg, MAJul 19, 1969 · N2390B · Destroyed NTSB NYC70D0081Accident · No injuriesClosedPiper PA-32 · Danvers, MAJul 18, 1969 · N4201R · Substantial damage NTSB NYC70D0063Accident · No injuriesClosedPiper PA-28 · East Boston, MAJul 17, 1969 · N9289W · Substantial damage NTSB NYC70F0153Accident · No injuriesClosedPiper PA-23 · Wenham, MAJul 15, 1969 · N4214P · Destroyed NTSB NYC70D0235Accident · Minor injuriesClosedCessna 172K · Marlborough, MAJul 4, 1969 · N78295 · Substantial damage NTSB NYC70A0002Accident · 1 fatalClosedPiper PA-28 · Falmouth, MAJul 1, 1969 · N6780J · Destroyed NTSB NYC70F0049Accident · No injuriesClosedBell 47D1 · Feeding Hlls, MAJun 30, 1969 · N4250A · Destroyed NTSB NYC70D0042Accident · No injuriesClosedCessna 177 · Oak Bluffs, MAJun 29, 1969 · N30056 · Substantial damage NTSB NYC70D0028Accident · No injuriesClosedCessna 150 · Westboro, MAJun 14, 1969 · N3208X · Substantial damage NTSB NYC70F0010Accident · Serious injuriesClosedCessna 180 · New Salem, MAJun 9, 1969 · N2936C · Substantial damage NTSB NYC69I0108Incident · No injuriesClosedBoeing 727-95 · Boston, MAJun 4, 1969 · N1635 · Minor damage NTSB NYC70D0053Accident · No injuriesClosedBeech A-23 · Worcester, MAJun 2, 1969 · N3656Q · Substantial damage NTSB NYC70F0015Accident · No injuriesClosedCessna 172I · Marshfield, MAJun 1, 1969 · N8391L · Substantial damage NTSB NYC69F0470Accident · Minor injuriesClosedAero Comdr 100 · Fall River, MAJun 1, 1969 · N3752X · Destroyed NTSB NYC70F0001Accident · Minor injuriesClosedMonocoupe 90 · Taunton, MAMay 31, 1969 · N38902 · Destroyed NTSB NYC69D0439Accident · Minor injuriesClosedCessna 182 · East Boston, MAMay 21, 1969 · N2101R · Substantial damage NTSB NYC69D0448Accident · No injuriesClosedCessna 150 · Newburyport, MAMay 18, 1969 · N6730F · Substantial damage NTSB NYC69D0443Accident · No injuriesClosedCessna 180 · Middlefield, MAMay 4, 1969 · N4575B · Substantial damage NTSB NYC69D0436Accident · No injuriesClosedPiper J3L-65 · Pittsfield, MAApr 29, 1969 · N31101 · Substantial damage NTSB NYC69D0449Accident · No injuriesClosedCessna 140 · Agawam, MAApr 26, 1969 · N3572V · Substantial damage NTSB NYC69D0404Accident · No injuriesClosedSchweizer SGU-2 · Tewksbury, MAApr 26, 1969 · N9844E · Substantial damage NTSB NYC69D0435Accident · No injuriesClosedPiper PA-32 · Norwood, MAApr 23, 1969 · N4073R · Substantial damage NTSB NYC69A0100Accident · Serious injuriesClosedDouglas DC-8 · E Boston, MAApr 13, 1969 · I-DIWM · No damage NTSB NYC69D0367Accident · No injuriesClosedCessna 172 · Bedford, MAMar 18, 1969 · N7320T · Substantial damage NTSB NYC69D0345Accident · No injuriesClosedCessna 150 · Falmouth, MAMar 15, 1969 · N23310 · Substantial damage NTSB NYC69F0341Accident · No injuriesClosedPiper PA-28 · Norwood, MAMar 12, 1969 · N1760J · Substantial damage NTSB NYC69D0366Accident · No injuriesClosedCessna 150 · Palmer, MAMar 10, 1969 · N5927E · Substantial damage NTSB NYC69D0346Accident · No injuriesClosedAero Comdr 100 · Shirley, MAMar 9, 1969 · N3790X · Substantial damage NTSB NYC69D0331Accident · No injuriesClosedCessna 182 · East Boston, MAMar 8, 1969 · N2434Q · Substantial damage NTSB NYC69F0359Accident · No injuriesClosedCessna 182K · Hyannis, MAMar 6, 1969 · N2677Q · Substantial damage NTSB NYC69F0379Accident · Minor injuriesClosedAeronca 11BC · Shutesbury, MAMar 1, 1969 · N85875 · Substantial damage NTSB NYC69A0084Accident · No injuriesClosedBeech 95-55 · Worcester, MAFeb 26, 1969 · N690H · Substantial damage NTSB NYC69F0323Accident · No injuriesClosedAero Comdr 100 · Westboro, MAFeb 2, 1969 · N2927T · Substantial damage NTSB NYC69D0337Accident · No injuriesClosedPiper PA-24 · Agawam, MAJan 31, 1969 · N4286A · Substantial damage NTSB NYC69F0306Accident · No injuriesClosedPiper PA-28 · Mendon, MAJan 19, 1969 · N8124W · Substantial damage NTSB NYC69D0290Accident · No injuriesClosedPiper PA-28 · Tewksbury, MAJan 12, 1969 · N4615R · Substantial damage NTSB NYC69D0320Accident · No injuriesClosedN American SNJ-6 · Turners Fall, MAJan 5, 1969 · N2864G · Substantial damage NTSB NYC69D0289Accident · No injuriesClosedCessna 172H · East Boston, MADec 24, 1968 · N1682F · Substantial damage NTSB NYC69F0285Accident · No injuriesClosedBeech E18S · Boston, MADec 19, 1968 · N2630K · Substantial damage NTSB NYC69F0258Accident · 1 fatalClosedBensen B-8 · Marion, MANov 23, 1968 · N59284 · Destroyed NTSB NYC69D0277Accident · No injuriesClosedBell 47G-5 · Rochester, MANov 23, 1968 · N7815S · Substantial damage NTSB NYC69F0302Accident · No injuriesClosedPiper PA-23 · Agawam, MANov 19, 1968 · N3263P · Substantial damage NTSB NYC69D0253Accident · No injuriesClosedPiper PA-28 · Tewksbury, MANov 19, 1968 · N6986W · Substantial damage NTSB NYC69D0254Accident · No injuriesClosedStinson 108-1 · Shirley, MANov 16, 1968 · N9154K · Substantial damage NTSB NYC69D0255Accident · No injuriesClosedPiper PA-28 · Norwood, MANov 15, 1968 · N1660J · Substantial damage NTSB NYC69F0269Accident · Serious injuriesClosedBell 206A · Hampden, MANov 14, 1968 · N3523T · Destroyed NTSB NYC69A0050Accident · 2 fatalClosedAmer Avco AA-1 · Westwood, MANov 2, 1968 · N5608L · Destroyed NTSB NYC69A0048Accident · 2 fatalClosedPiper PA-12 · Millbury, MAOct 27, 1968 · N3927M · Destroyed NTSB NYC69F0227Accident · No injuriesClosedCessna 150F · Bedford, MAOct 23, 1968 · N8748G · Substantial damage