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 NYC69F0376Accident · No injuriesClosedCessna 140 · Biddeford, MEApr 6, 1969 · N2140N · Substantial damage NTSB NYC69F0373Accident · No injuriesClosedCessna 15OF · Sanford, MEApr 1, 1969 · N6256R · Substantial damage NTSB NYC69F0375Accident · No injuriesClosedBeech A23-24 · Augusta, MEMar 28, 1969 · N5785V · Substantial damage NTSB NYC69D0380Accident · No injuriesClosedLuscombe 8E · Dexter, MEMar 23, 1969 · N2618K · Substantial damage NTSB NYC69F0347Accident · Minor injuriesClosedStinson 108-2 · Hampden, MEMar 15, 1969 · N391C · Substantial damage NTSB NYC69D0361Accident · No injuriesClosedCessna 172I · Biddeford, MEMar 15, 1969 · N35501 · Substantial damage NTSB NYC69D0314Accident · No injuriesClosedPiper PA-23 · Pittsfield, MEFeb 6, 1969 · N6370Y · Substantial damage NTSB NYC69D0315Accident · No injuriesClosedCessna 170 · Burlington, MEFeb 1, 1969 · N3532D · Substantial damage NTSB NYC69F0268Accident · Serious injuriesClosedPiper PA-22 · Phippsburg, MENov 3, 1968 · N5042Z · Substantial damage NTSB NYC69F0238Accident · No injuriesClosedCessna 170 · Auburn, MENov 3, 1968 · N2621V · Substantial damage NTSB NYC69F0228Accident · No injuriesClosedCessna 140A · Monroe, MEOct 30, 1968 · CF-KMM · Substantial damage NTSB NYC69A0049Accident · Minor injuriesClosedBeech 95-D55 · Waterville, MEOct 29, 1968 · N304HA · Destroyed NTSB NYC69D0251Accident · No injuriesClosedPiper PA-22 · Wiscasset, MEOct 27, 1968 · N4724Z · Substantial damage NTSB NYC69A0038Accident · 2 fatalClosedPiper PA-22 · Bath, MESep 20, 1968 · N5861Z · Destroyed NTSB NYC69F0199Accident · No injuriesClosedBeech H35 · Augusta, MESep 19, 1968 · N7914D · Substantial damage NTSB NYC69D0167Accident · Minor injuriesClosedAeronca O-58B · N.New Portland, MESep 7, 1968 · N46058 · Substantial damage NTSB NYC69F0124Accident · Minor injuriesClosedLuscombe 8A · Fryeburg, MESep 4, 1968 · N2107K · Destroyed NTSB NYC69F0135Accident · No injuriesClosedCessna 170 · Turner, MESep 2, 1968 · N4226V · Substantial damage NTSB NYC69D0168Accident · No injuriesClosedPiper PA-25 · Bridgton, MESep 2, 1968 · N8941W · Substantial damage NTSB NYC69D0175Accident · No injuriesClosedFardy Baby C · Brunswick, MESep 1, 1968 · N6547D · Substantial damage NTSB NYC69D0136Accident · No injuriesClosedTaylorcraft BC12-D · Norway, MESep 1, 1968 · N43989 · Substantial damage NTSB NYC69D0177Accident · No injuriesClosedPitts Spec SC-1 · Sanford, MEAug 31, 1968 · N4111 · Substantial damage NTSB NYC69D0188Accident · Minor injuriesClosedPiper PA-28 · Jackman, MEAug 25, 1968 · N8543W · Substantial damage NTSB NYC69D0153Accident · No injuriesClosedCessna 172 · Lincoln, MEAug 25, 1968 · N2633U · Substantial damage NTSB NYC69A0021Accident · Serious injuriesClosedDouglas DC-8 · Presque Isle, MEAug 14, 1968 · N812PA · No damage NTSB NYC69D0108Accident · Minor injuriesClosedCessna 120 · Turner, MEJul 28, 1968 · N4033N · Substantial damage NTSB NYC69D0107Accident · No injuriesClosedCessna 140 · Vinalhaven, MEJul 27, 1968 · N72786 · Substantial damage NTSB NYC69F0090Accident · No injuriesClosedCessna 150 · Portland, MEJul 26, 1968 · N8602S · Substantial damage NTSB NYC69D0081Accident · No injuriesClosedPiper PA-28 · Union, MEJul 15, 1968 · N7567W · Substantial damage NTSB NYC69D0091Accident · No injuriesClosedErco 415-C · Mexico, MEJul 14, 1968 · N99269 · Substantial damage NTSB NYC69D0065Accident · No injuriesClosedCessna 140 · Bethel, MEJul 11, 1968 · N1885V · Substantial damage NTSB NYC69F0010Accident · No injuriesClosedCessna 150 · Pittsfield, MEJun 16, 1968 · N8105F · Substantial damage NTSB NYC69D0031Accident · No injuriesClosedCessna 172 · Meddybemps, MEJun 16, 1968 · N8549U · Substantial damage NTSB NYC68F0490Accident · No injuriesClosedThurston TSC-1A · Sanford, MEJun 8, 1968 · N1968T · Substantial damage NTSB NYC68D0480Accident · No injuriesClosedPiper PA-28 · Fort Kent, MEMay 24, 1968 · N3924K · Substantial damage NTSB NYC69F0030Accident · No injuriesClosedPiper PA-23 · Houlton, MEMay 17, 1968 · CF-CCC · Substantial damage NTSB NYC68F0440Accident · Serious injuriesClosedPiper J3C · Topsham, MEApr 13, 1968 · N42821 · Substantial damage NTSB NYC68A0113Accident · 2 fatalClosedLake LA-4 · Sanford, MEMar 29, 1968 · N7601L · Destroyed NTSB NYC68D0402Accident · No injuriesClosedAeronca 7AC · Madawaska, MEMar 23, 1968 · N2338E · Substantial damage NTSB NYC68D0400Accident · No injuriesClosedPiper PA-28 · Waterville, MEMar 14, 1968 · N5716W · Substantial damage NTSB NYC68D0399Accident · No injuriesClosedCessna 150 · Caribou, MEFeb 28, 1968 · N6580F · Substantial damage NTSB NYC68A0103Accident · 3 fatalClosedPiper PA-28 · Auburn, MEFeb 28, 1968 · N4761L · Destroyed NTSB NYC68F0371Accident · No injuriesClosedBeech 35 · Old Town, MEFeb 25, 1968 · N3114V · Substantial damage NTSB NYC68F0367Accident · No injuriesClosedMooney M20C · Augusta, MEFeb 4, 1968 · N7874V · Substantial damage NTSB NYC68D0356Accident · No injuriesClosedCessna 140 · Milo, MEJan 20, 1968 · N89261 · Substantial damage NTSB NYC68D0338Accident · No injuriesClosedLuscombe 8F · Trenton, MEJan 14, 1968 · N9903C · Substantial damage NTSB NYC68F0267Accident · No injuriesClosedTaylorcraft BC12D1 · Waterville, MENov 5, 1967 · N44444 · Substantial damage NTSB NYC68A0061Accident · 1 fatalClosedRepublic RC-3 · Ashland, MEOct 18, 1967 · N6569K · Destroyed NTSB NYC68F0203Accident · No injuriesClosedPiper PA-28 · Auburn, MESep 24, 1967 · N9514W · Substantial damage NTSB NYC68D0229Accident · No injuriesClosedAeronca 7DC · Augusta, MESep 9, 1967 · N3926A · Substantial damage