Skip to content

NTSB investigations, ME

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" = 'ME' 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\" = 'ME' 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" = 'ME' 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 NYC73DNC66Accident · No injuriesClosedCessna 172L · Carrabassett, MEApr 15, 1973 · N3821Q · Substantial damage NTSB NYC73DNC64Accident · No injuriesClosedCessna 120 · Rangely, MEMar 30, 1973 · N76474 · Substantial damage NTSB NYC73DNC65Accident · No injuriesClosedPiper PA-28 · Bangor, MEMar 27, 1973 · N9513J · Substantial damage NTSB NYC73AN122Accident · 2 fatalClosedBeech 65-A90 · Portland, MEMar 13, 1973 · N791K · Destroyed NTSB NYC73DNC58Accident · No injuriesClosedPiper PA-28 · Machias, MEFeb 28, 1973 · N575CA · Substantial damage NTSB NYC73DNC54Accident · No injuriesClosedMooney M20E · Biddeford, MEFeb 27, 1973 · N9254M · Substantial damage NTSB NYC73DNC60Accident · No injuriesClosedCessna 150 · Eastport, MEFeb 24, 1973 · N8949S · Substantial damage NTSB NYC73DNC53Accident · No injuriesClosedLuscombe 8E · Meddybemps, MEFeb 19, 1973 · N1740K · Substantial damage NTSB NYC73FNC52Accident · No injuriesClosedMooney M20F · Caribou, MEFeb 10, 1973 · N2917L · Substantial damage NTSB NYC73ANC47Accident · No injuriesClosedCessna 310D · Brewer, MEJan 14, 1973 · N6930T · Substantial damage NTSB NYC73AN089Accident · 2 fatalClosedCessna 170A · Turner, MEDec 27, 1972 · N1452D · Destroyed NTSB NYC73DNC41Accident · No injuriesClosedCessna 150 · Brewer, MEDec 2, 1972 · N17046 · Substantial damage NTSB NYC73DNC42Accident · No injuriesClosedLuscombe 8F · Turner, MENov 25, 1972 · N1553B · Substantial damage NTSB NYC73DNC38Incident · No injuriesClosedPiper PA-23 · Stonington, MENov 21, 1972 · N5933Y · Minor damage NTSB NYC73DNC37Incident · Minor injuriesClosedCessna 172 · Waterville, MEOct 27, 1972 · N1747F · Minor damage NTSB NYC73DNC36Accident · Minor injuriesClosedAeronca 7AC · Northeast Hbr, MEOct 27, 1972 · N3088E · Substantial damage NTSB NYC73FNC34Accident · No injuriesClosedPiper PA-30 · Pittsfield, MEOct 26, 1972 · N7283Y · Substantial damage NTSB NYC73FNC33Accident · No injuriesClosedSikorsky S-55B · Bridgton, MEOct 26, 1972 · N6734 · Substantial damage NTSB NYC73DNC35Accident · Minor injuriesClosedCessna 150 · Rockland, MEOct 26, 1972 · N5664E · Destroyed NTSB NYC73FNC31Accident · No injuriesClosedPiper PA-28R · East Corinth, MEOct 14, 1972 · N4694J · Substantial damage NTSB NYC73FNC27Accident · Minor injuriesClosedPiper PA-20 · Hampden, MEOct 8, 1972 · N1556A · Destroyed NTSB NYC73INO53Incident · No injuriesClosedCessna 195 · Ellsworth, MEOct 3, 1972 · N9879A · Minor damage NTSB NYC73AN047Accident · 1 fatalClosedBell H-13G · Readfield, MESep 27, 1972 · N64816 · Substantial damage NTSB NYC73FNC30Accident · No injuriesClosedCessna 150 · Turner, MESep 20, 1972 · N6354G · Substantial damage NTSB NYC73DNC25Accident · Minor injuriesClosedCessna 185C · Skinner, MESep 13, 1972 · N5858T · Destroyed NTSB NYC73FNC22Accident · Serious injuriesClosedCessna 150 · Pittsfield, MESep 5, 1972 · N7728E · Substantial damage NTSB NYC73FNC19Accident · No injuriesClosedCessna 182 · Sanford, MEAug 31, 1972 · N5610B · Substantial damage NTSB NYC73AN038Accident · No injuriesClosedCessna 182A · Thomaston, MEAug 26, 1972 · N4874D · Destroyed NTSB NYC73FNC29Accident · Serious injuriesClosedSchleicher KA-6 · Farmingdale, MEAug 19, 1972 · N4333 · Substantial damage NTSB NYC73DNC18Accident · Minor injuriesClosedPiper PA-22 · Tenants Harbor, MEAug 13, 1972 · N4776Z · Substantial damage NTSB NYC73FNC14Accident · No injuriesClosedCessna 210D · Oxford, MEJul 29, 1972 · N3940Y · Substantial damage NTSB NYC73DNC07Incident · No injuriesClosedBeagle B206S · Machias, MEJul 24, 1972 · N1885S · Minor damage NTSB NYC73DNC05Accident · Minor injuriesClosedBoeing A-75 · Minot, MEJul 23, 1972 · N57849 · Substantial damage NTSB NYC73DNC17Accident · Minor injuriesClosedBoeing E75 · Ft.Fairfield, MEJul 18, 1972 · N9058H · Substantial damage NTSB NYC73DNC13Accident · No injuriesClosedPiper PA-28 · Monticello, MEJul 18, 1972 · N9430J · Substantial damage NTSB NYC73AN010Accident · 4 fatalClosedCessna T337D · Belfast, MEJul 14, 1972 · N86018 · Destroyed NTSB NYC73FNC06Accident · No injuriesClosedPiper PA-24 · Wiscasset, MEJul 8, 1972 · N666TS · Substantial damage NTSB NYC73DNC03Accident · No injuriesClosedBell 47D1 · Readfield, MEJul 6, 1972 · N10193 · Substantial damage NTSB NYC73FNC02Accident · No injuriesClosedCessna 205 · Fayette, MEJul 5, 1972 · N100QP · Substantial damage NTSB NYC72FNC53Accident · Serious injuriesClosedCessna 170B · Greenville, MEJun 21, 1972 · N2592C · Destroyed NTSB NYC72DNC52Accident · No injuriesClosedCessna 182C · N.New Portland, MEMay 27, 1972 · N8951T · Substantial damage NTSB NYC72FNC42Accident · Serious injuriesClosedStinson 108-3 · Princeton, MEApr 30, 1972 · N6070M · Substantial damage NTSB NYC72FNC40Accident · Minor injuriesClosedCessna 175 · Old Town, MEApr 30, 1972 · N7543M · Substantial damage NTSB NYC72FNC36Accident · No injuriesClosedCessna 195A · Biddeford, MEApr 9, 1972 · N1513D · Substantial damage NTSB NYC72DNC37Accident · No injuriesClosedCessna 150 · Auburn, MEApr 9, 1972 · N3610J · Substantial damage NTSB NYC72DNC39Accident · No injuriesClosedPiper PA-18 · Clinton, MEMar 30, 1972 · N4275Z · Substantial damage NTSB NYC72FNC32Accident · No injuriesClosedCessna 180H · Chamberlain, MEMar 16, 1972 · N91309 · Substantial damage NTSB NYC72DNC30Accident · Minor injuriesClosedBeech 58 · Millinocket, MEMar 7, 1972 · N4626A · Substantial damage NTSB NYC72DNC29Accident · No injuriesClosedPiper PA-28 · Auburn, MEFeb 25, 1972 · N9514W · Substantial damage NTSB NYC72FNC21Incident · 1 fatalClosedStinson 108-3 · Princeton, MEJan 7, 1972 · N6070M · Minor damage