Skip to content

NTSB investigations, MA

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 UNK64X3732Accident · No injuriesClosedPiper PA22 · Beverly, MASep 2, 1964 · N8011C · Substantial damage NTSB UNK64X3715Accident · No injuriesClosedCarson S-C4 · Worcester, MASep 1, 1964 · N868Z · Substantial damage NTSB UNK64X3669Accident · No injuriesClosedPiper J3C · Tewksbury, MAAug 29, 1964 · N70399 · Substantial damage NTSB UNK64X3638Accident · Minor injuriesClosedPiper PA22 · Gt Barrington, MAAug 28, 1964 · N4721Z · Substantial damage NTSB UNK64X3415Accident · No injuriesClosedCessna 182 · Chatham, MAAug 16, 1964 · N2726G · Substantial damage NTSB UNK64X3384Accident · Serious injuriesClosedPiper PA18 · Gay Island, MAAug 14, 1964 · N3769Z · Destroyed NTSB UNK64X3304Accident · No injuriesClosedPiper PA22 · Norfolk, MAAug 9, 1964 · N1413C · Destroyed NTSB UNK64X3300Accident · No injuriesClosedBeechcraft 35 · Norwood, MAAug 9, 1964 · N135JL · Substantial damage NTSB UNK64X3265Accident · No injuriesClosedLuscombe 8A · Westboro, MAAug 8, 1964 · N77989 · Substantial damage NTSB UNK64X3231Accident · 2 fatalClosedPiper PA-23 · E Falmouth, MAAug 5, 1964 · N5485Y · Destroyed NTSB UNK64X3230Accident · No injuriesClosedBeechcraft E18S · E Boston, MAAug 5, 1964 · N48K · Substantial damage NTSB UNK64X3205Incident · No injuriesClosedBell 47G · Carver, MAAug 4, 1964 · N2814B · Minor damage NTSB UNK64X3143Accident · No injuriesClosedPiper PA22 · Lawrence, MAAug 1, 1964 · N8405D · Substantial damage NTSB UNK64X3094Accident · 2 fatalClosedMooney M-20A · Provincetown, MAJul 28, 1964 · N6024 · Destroyed NTSB UNK64X3077Accident · No injuriesClosedBell 47G · Plymouth, MAJul 27, 1964 · N932B · Substantial damage NTSB UNK64X3028Accident · No injuriesClosedBell 47G2A1 · Westport, MAJul 25, 1964 · N73952 · Substantial damage NTSB UNK64X2746Accident · No injuriesClosedBeechcraft 35 · Hyannis, MAJul 10, 1964 · N16W · Substantial damage NTSB UNK64X2585Accident · 4 fatalClosedBeech A35 · Nantucket, MAJun 30, 1964 · N782B · Destroyed NTSB UNK64X2564Accident · No injuriesClosedBell 47J2 · Waltham, MAJun 29, 1964 · N8499E · Substantial damage NTSB UNK64X2532Accident · No injuriesClosedPiper PA30 · Fitchburg, MAJun 28, 1964 · N7106Y · Substantial damage NTSB UNK64X2517Accident · No injuriesClosedPiper PA28 · Northhampton, MAJun 27, 1964 · N5675W · Substantial damage NTSB UNK64X2507Accident · No injuriesClosedTaylorcraft BC12D · Osterville, MAJun 27, 1964 · N95085 · Substantial damage NTSB UNK64X2383Accident · 2 fatalClosedAero Cmdr 680 · Southhampton, MAJun 19, 1964 · N344S · Destroyed NTSB UNK64X2301Accident · No injuriesClosedBeechcraft 23 · Worcester, MAJun 15, 1964 · N8758M · Substantial damage NTSB UNK64X2213Accident · Minor injuriesClosedPiper PA23 · Bedford, MAJun 10, 1964 · N3006P · Substantial damage NTSB UNK64X2087Accident · Minor injuriesClosedCessna 172 · Braintree, MAJun 3, 1964 · N4151F · Destroyed NTSB UNK64X2043Accident · Serious injuriesClosedLaister LK10A · Turnersfalls, MAMay 31, 1964 · N57541 · Destroyed NTSB UNK64X2028Accident · No injuriesClosedCessna 195B · Chatham, MAMay 30, 1964 · N3070B · Substantial damage NTSB UNK64X1941Accident · No injuriesClosedCessna 172 · Edgartown, MAMay 24, 1964 · N2484U · Substantial damage NTSB UNK64X1883Accident · No injuriesClosedCessna 150 · Northhampton, MAMay 22, 1964 · N6492T · Substantial damage NTSB UNK64X1678Accident · No injuriesClosedAeronca 7AC · Fall River, MAMay 9, 1964 · N85104 · Substantial damage NTSB UNK64X1660Accident · 1 fatalClosedAeronca 7BCM · Truro Beach, MAMay 7, 1964 · N1145V · Destroyed NTSB UNK64X1638Accident · No injuriesClosedMooney M20C · Bedford, MAMay 6, 1964 · N6268U · Substantial damage NTSB UNK64X1614Accident · Minor injuriesClosedChampion 7FC · Tewksbury, MAMay 4, 1964 · N9900Y · Substantial damage NTSB UNK64X1471Accident · No injuriesClosedMooney MK21 · Marlboro, MAApr 26, 1964 · N6808U · Substantial damage NTSB UNK64X1258Accident · No injuriesClosedCessna 140A · Marlboro, MAApr 11, 1964 · N89489 · Substantial damage NTSB UNK64X1257Accident · No injuriesClosedLuscombe 8A · Norwood, MAApr 11, 1964 · N1471K · Substantial damage NTSB UNK64X1198Accident · No injuriesClosedPiper PA22 · Northampton, MAApr 6, 1964 · N7734D · Substantial damage NTSB UNK64X1155Accident · No injuriesClosedStinson 108 2 · Gr Barrington, MAApr 4, 1964 · N970D · Destroyed NTSB UNK64X1153Accident · Minor injuriesClosedCarson C4 · Boston, MAApr 3, 1964 · N612X · Substantial damage NTSB UNK64X1137Accident · Serious injuriesClosedCessna 140 · Plymouth, MAApr 2, 1964 · N76641 · Destroyed NTSB UNK64X1026Accident · 1 fatalClosedCessna 140 · Westboro, MAMar 23, 1964 · N76660 · Destroyed NTSB UNK64X0893Accident · No injuriesClosedPiper PA28 · Norwood, MAMar 12, 1964 · N5449W · Substantial damage NTSB UNK64X0866Accident · 3 fatalClosedDouglas DC-4 · Boston, MAMar 10, 1964 · N384 · Destroyed NTSB UNK64X0854Accident · No injuriesClosedLockheed L-749 · Boston, MAMar 9, 1964 · N91209 · Substantial damage NTSB UNK64X0733Accident · No injuriesClosedBeechcraft 35G · Westboro, MAFeb 28, 1964 · N4475D · Destroyed NTSB UNK64X0361Accident · No injuriesClosedAeronca 7AC · Hatfield, MAJan 26, 1964 · N2432E · Substantial damage NTSB UNK64X0333Accident · No injuriesClosedPiper J3C · Fitchburg, MAJan 23, 1964 · N7259H · Substantial damage NTSB UNK64X0204Accident · No injuriesClosedPiper PA22 · Boston, MAJan 10, 1964 · N5704D · Substantial damage NTSB UNK64X0133Accident · No injuriesClosedPiper PA22 · Worcester, MAJan 3, 1964 · N3632Z · Substantial damage