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 NYC66A0122Accident · 2 fatalClosedTaylorcraft DCO-65 · Bethel Maine, MEApr 23, 1966 · N46253 · Destroyed NTSB NYC66F0628Accident · No injuriesClosedBeechcraft A23 · Augusta, MEApr 17, 1966 · N3512R · Substantial damage NTSB NYC66F0578Accident · No injuriesClosedAero Cmdr 680E · Augusta, MEApr 7, 1966 · N6288B · Substantial damage NTSB NYC66F0531Accident · No injuriesClosedErcoupe 415-C · Waterville, MEFeb 22, 1966 · N2306H · Substantial damage NTSB NYC66F0520Accident · No injuriesClosedCessna 120 · Waldo, MEFeb 19, 1966 · N2773N · Substantial damage NTSB NYC66A0088Accident · 1 fatalClosedPiper PA-24 · Monticello, MEFeb 11, 1966 · N8514P · Destroyed NTSB NYC66F0482Accident · No injuriesClosedCessna 310B · Portland, MEJan 28, 1966 · N3310 · Substantial damage NTSB NYC66F0442Accident · No injuriesClosedCessna 172 · Houlton, MEJan 22, 1966 · N5400T · Substantial damage NTSB NYC66F0407Accident · No injuriesClosedPiper PA-28 · Millinocket, MEJan 4, 1966 · N6986W · Substantial damage NTSB NYC66D0438Accident · Minor injuriesClosedLuscombe 8A · Sanford, MEDec 31, 1965 · N71424 · Substantial damage NTSB NYC66F0427Accident · No injuriesClosedCessna 172 · Lewiston, MEDec 23, 1965 · N8197B · Substantial damage NTSB NYC66D0350Accident · No injuriesClosedCessna 180 · Mariaville, MENov 4, 1965 · N2620Y · Substantial damage NTSB NYC66F0349Accident · No injuriesClosedPiper PA-23 · Old Town, MENov 3, 1965 · N3372P · Substantial damage NTSB NYC66F0330Accident · Minor injuriesClosedLuscombe 8A · Brewer, MEOct 24, 1965 · N1269K · Substantial damage NTSB NYC66F0338Accident · Serious injuriesClosedPiper PA-12S · Presley Lake, MEOct 17, 1965 · CF-NYJ · Destroyed NTSB NYC66F0264Accident · No injuriesClosedCessna 120 · Turner, MESep 28, 1965 · N3070N · Substantial damage NTSB NYC66F0236Accident · Minor injuriesClosedPiper PA-24 · Old Town, MESep 21, 1965 · N7521P · Substantial damage NTSB NYC66D0269Accident · No injuriesClosedAeronca 65-TAC · Ashland, MESep 19, 1965 · N36823 · Substantial damage NTSB NYC66F0211Accident · Serious injuriesClosedStinson 108-1 · Castine, MESep 6, 1965 · N97988 · Destroyed NTSB NYC66F0237Accident · No injuriesClosedTaylorcraft BC-12D · Island Falls, MESep 5, 1965 · N43479 · Substantial damage NTSB NYC66F0194Accident · No injuriesClosedBeechcraft 35 · Augusta, MEAug 9, 1965 · N403B · Substantial damage NTSB NYC66D0212Accident · No injuriesClosedCessna 182F · Blue Hill, MEAug 6, 1965 · N3517U · Substantial damage NTSB NYC66D0098Accident · No injuriesClosedPiper J-3 · Redington Pond, MEJul 5, 1965 · N49618 · Substantial damage NTSB NYC66F0044Accident · No injuriesClosedTaylorcraft BL-65 · Harrison, MEJun 17, 1965 · N27672 · Substantial damage NTSB NYC66D0028Accident · No injuriesClosedTaylorcraft BC-12D · Rumford, MEMay 30, 1965 · N43292 · Substantial damage NTSB NYC65F0174Accident · No injuriesClosedPiper PA-18 · Old Town, MEApr 7, 1965 · N1615A · Substantial damage NTSB NYC65F0130Accident · No injuriesClosedAeronca 7BCM · Fryeburg, MEApr 4, 1965 · N3927A · Substantial damage NTSB NYC65F0098Accident · No injuriesClosedFairchild 24R-40 · Winterport, MEApr 4, 1965 · N232E · Destroyed NTSB UNK65X1052Accident · No injuriesClosedTaylorcraft BC12D · Brewer, MEDec 19, 1964 · N44336 · Substantial damage NTSB UNK65X1035Accident · No injuriesClosedPiper PA28 · Old Town, MEDec 17, 1964 · N6413W · Substantial damage NTSB UNK65X0485Accident · No injuriesClosedCessna 172E · Lubec, MEOct 30, 1964 · N5561T · Substantial damage NTSB UNK65X0455Accident · No injuriesClosedBell 47G · Mt Katahdin, MEOct 27, 1964 · N951B · Substantial damage NTSB UNK65X0442Accident · 1 fatalClosedPiper PA-18S · Kokadjo, MEOct 25, 1964 · N8057C · Substantial damage NTSB UNK65X0249Accident · Serious injuriesClosedPiper PA22 · Wiscasset, MEOct 11, 1964 · N5606Z · Destroyed NTSB UNK64X3975Accident · No injuriesClosedAeronca 7AC · West Newfield, MESep 13, 1964 · N84837 · Substantial damage NTSB UNK64X3948Accident · No injuriesClosedPiper J3C · Veazie, MESep 12, 1964 · N3336N · Substantial damage NTSB UNK64X3830Accident · Serious injuriesClosedCessna 170 · Princeton, MESep 6, 1964 · N2510V · Substantial damage NTSB UNK64X3816Accident · Minor injuriesClosedPiper PA22 · Patten, MESep 6, 1964 · N8858D · Substantial damage NTSB UNK64X3640Accident · No injuriesClosedBeechcraft 35A33 · Machias, MEAug 28, 1964 · N476T · Destroyed NTSB UNK64X3573Accident · Minor injuriesClosedPiper J3C · Somerset City, MEAug 24, 1964 · N25784 · Substantial damage NTSB UNK64X2898Accident · No injuriesClosedCessna 170B · Isleboro, MEJul 18, 1964 · N3500C · Substantial damage NTSB UNK64X1980Accident · No injuriesClosedPiper PA23 · Millinocket, MEMay 27, 1964 · N5090Y · Substantial damage NTSB UNK64X1946Accident · Serious injuriesClosedPiper PA20 · Greenville, MEMay 24, 1964 · N8043C · Destroyed NTSB UNK64X1927Accident · Minor injuriesClosedPiper PA22 · Rumford, MEMay 24, 1964 · N9511D · Substantial damage NTSB UNK64X1780Accident · No injuriesClosedPiper PA22 · Augusta, MEMay 16, 1964 · N5955Z · Substantial damage NTSB UNK64X1595Accident · Minor injuriesClosedLake LA4 · Raymond, MEMay 3, 1964 · N1019L · Destroyed NTSB UNK64X1550Accident · No injuriesClosedBeechcraft T34 · Presque Isle Ne, MEMay 1, 1964 · N10304 · Substantial damage NTSB UNK64X1473Accident · Minor injuriesClosedPiper PA12 · Lake Village Ind, MEApr 26, 1964 · N4356N · Substantial damage NTSB UNK64X1472Accident · No injuriesClosedPiper PA22 · Freeport, MEApr 26, 1964 · N5638Z · Substantial damage NTSB UNK64X1391Accident · No injuriesClosedPiper PA22 · Houlton, MEApr 20, 1964 · N5646Z · Substantial damage