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 NYC77FNE19Accident · No injuriesClosedCassutt 3 · Gardner, MAMay 21, 1977 · N164 · Substantial damage NTSB NYC77FA058Accident · Serious injuriesClosedPiper PA-30 · Plymouth, MAMay 20, 1977 · N8661Y · Substantial damage NTSB NYC77FNE17Accident · No injuriesClosedLake LA-4 · Ashburnham, MAApr 30, 1977 · N5013L · Substantial damage NTSB NYC77FNA16Accident · No injuriesClosedCessna 172 · Marlboro, MAApr 23, 1977 · N79879 · Substantial damage NTSB NYC77FNE15Accident · No injuriesClosedCessna 150 · Turner Falls, MAApr 11, 1977 · N51343 · Substantial damage NTSB NYC77FNA15Accident · No injuriesClosedPiper PA-24 · Plymouth, MAApr 10, 1977 · N5855P · Substantial damage NTSB NYC77FA050Accident · Serious injuriesClosedConvair 240 · Hyannis, MAApr 9, 1977 · N10AV · Destroyed NTSB NYC77FNE12Accident · Minor injuriesClosedLuscombe 8C · Pittsfield, MAMar 27, 1977 · N28725 · Substantial damage NTSB NYC77DNA14Accident · No injuriesClosedCessna 150 · Hanson, MAMar 27, 1977 · N8717S · Substantial damage NTSB NYC77FNA13Accident · No injuriesClosedCessna 182 · Boston, MAMar 13, 1977 · N42264 · Substantial damage NTSB NYC77FA036Accident · 1 fatalClosedCessna 150M · Fitchburg, MAMar 12, 1977 · N8650U · Substantial damage NTSB NYC77FNE10Accident · No injuriesClosedCessna 150 · Hopedale, MAMar 3, 1977 · N714CP · Substantial damage NTSB NYC77DNA12Accident · No injuriesClosedGrum Amer AA-1B · Tewksbury, MAFeb 10, 1977 · N6325L · Substantial damage NTSB NYC77FNA11Accident · No injuriesClosedCessna 172M · Plymouth, MAFeb 6, 1977 · N9654Q · Substantial damage NTSB NYC77FNAL0Accident · No injuriesClosedBeech E18S · Boston, MAJan 31, 1977 · N8111 · Substantial damage NTSB NYC77FNA09Accident · Minor injuriesClosedCessna 172M · N.Andover, MAJan 16, 1977 · N64264 · Substantial damage NTSB NYC77DNA08Accident · No injuriesClosedPiper PA-28 · Beverly, MAJan 6, 1977 · N15963 · Substantial damage NTSB NYC77FA022Accident · 2 fatalClosedPiper PA-23 · Danvers, MADec 21, 1976 · N66HR · Destroyed NTSB NYC77FNA07Accident · Serious injuriesClosedTed Smith 601 · Framingham Ctr, MADec 12, 1976 · N90337 · Destroyed NTSB NYC76DNA04Accident · No injuriesClosedPiper PA-24 · Chatham, MANov 20, 1976 · N9258P · Substantial damage NTSB NYC77DNA03Accident · No injuriesClosedAero Comdr 560A · Provincetown, MANov 9, 1976 · CFMLQ · Substantial damage NTSB NYC77FNE02Accident · Serious injuriesClosedSchweizer SGS233 · Pittsfield, MAOct 17, 1976 · N33977 · Destroyed NTSB NYC77FNA01Accident · No injuriesClosedEvans VP1 · Stow, MAOct 11, 1976 · N106JM · Substantial damage NTSB NYC76FNA54Accident · No injuriesClosedPiper PA-12 · Pembroke, MASep 26, 1976 · N3913M · Substantial damage NTSB NYC76FNA52Accident · No injuriesClosedCessna 172 · Middleboro, MASep 12, 1976 · N80420 · Substantial damage NTSB NYC76FNA51Accident · No injuriesClosedStearman A75 · Norwood, MASep 9, 1976 · N145N · Substantial damage NTSB NYC76DNA53Accident · No injuriesClosedCessna 172K · Methuen, MASep 9, 1976 · N78179 · Substantial damage NTSB NYC76FNE33Accident · Serious injuriesClosedSchweizer SGS126 · Sterling, MAAug 21, 1976 · N1106S · Substantial damage NTSB NYC76FNE31Accident · Serious injuriesClosedLake LA-4 · Grt Barrington, MAAug 10, 1976 · N39359 · Substantial damage NTSB NYC76AN119Accident · Serious injuriesClosedCessna U206F · Tuckernuck Is, MAAug 5, 1976 · N35919 · Substantial damage NTSB NYC76AN117Accident · No injuriesClosedBeech 65 · Bedford, MAJul 27, 1976 · N12 · Substantial damage NTSB NYC76FNA46Accident · No injuriesClosedPiper PA-32 · Tewksbury, MAJul 26, 1976 · N3893W · Substantial damage NTSB NYC76FNA45Accident · No injuriesClosedCessna 150L · Freetown, MAJul 25, 1976 · N6754G · Substantial damage NTSB NYC76DNA44Accident · Minor injuriesClosedCessna 140 · Norfolk, MAJul 20, 1976 · N72708 · Substantial damage NTSB NYC76FNE29Accident · No injuriesClosedCessna 150J · Southbridge, MAJul 18, 1976 · N60412 · Substantial damage NTSB NYC76AN111Accident · 1 fatalClosedPiper PA-28R · Bedford, MAJul 16, 1976 · N3298R · Substantial damage NTSB NYC76FNA47Accident · No injuriesClosedGrum Amer AA-5 · Stow, MAJul 14, 1976 · N8899L · Substantial damage NTSB NYC76FNE27Accident · Serious injuriesClosedGlobe GC-1B · Gardner, MAJul 5, 1976 · N78315 · Destroyed NTSB NYC76FNA41Accident · No injuriesClosedPiper PA-18 · Chatham, MAJul 3, 1976 · N6989D · Substantial damage NTSB NYC76DNA40Accident · Minor injuriesClosedCessna 150 · Shirley, MAJun 27, 1976 · N3883J · Substantial damage NTSB NYC76AN105Accident · 4 fatalClosedCessna 172 · Turo, MAJun 26, 1976 · CF-QNG · Destroyed NTSB NYC76FNE24Accident · Minor injuriesClosedCessna 150G · Westboro, MAJun 7, 1976 · N8347G · Substantial damage NTSB NYC76AM1O2Accident · 2 fatalClosedBeech B35 · Hyannis, MAJun 6, 1976 · N8919A · Destroyed NTSB NYC76FNE22Accident · Minor injuriesClosedMooney M20C · Westboro, MAMay 30, 1976 · N6793N · Substantial damage NTSB NYC76FNE20Accident · No injuriesClosedPiper PA-12 · Pittsfield, MAMay 23, 1976 · N4054M · Substantial damage NTSB NYC76DNA39Accident · No injuriesClosedStinson 108-3 · Oak Bluffs, MAMay 23, 1976 · N6275M · Substantial damage NTSB NYC76FNA38Accident · No injuriesClosedCessna 150H · Shirley, MAMay 13, 1976 · N7169S · Substantial damage NTSB NYC76DNA35Accident · No injuriesClosedCessna 150 · Norfolk, MAApr 20, 1976 · N63439 · Substantial damage NTSB NYC76DNA34Accident · No injuriesClosedPiper PA-16 · Bedford, MAApr 16, 1976 · N5855H · Substantial damage NTSB NYC76DNA33Accident · No injuriesClosedMooney M20C · Bedford, MAApr 2, 1976 · N9788M · Substantial damage