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 NYC68D0146Accident · No injuriesClosedCessna 180 · The Forks, MESep 4, 1967 · N1745C · Substantial damage NTSB NYC68A0039Accident · Minor injuriesClosedBell 47G-5 · Westfield, MESep 1, 1967 · N7800S · Destroyed NTSB NYC68F0124Accident · No injuriesClosedPiper PA-20S · Bucksport, MEAug 30, 1967 · N1835A · Substantial damage NTSB NYC68D0129Accident · No injuriesClosedPiper PA-20 · Waterville, MEAug 23, 1967 · N7623K · Substantial damage NTSB NYC68D0145Accident · No injuriesClosedTaylorcraft BC12-D · Bethel, MEAug 21, 1967 · N24321 · 2 aircraft · Substantial damage NTSB NYC68D0117Accident · No injuriesClosedPiper PA-22 · Augusta, MEAug 11, 1967 · N5042Z · Substantial damage NTSB NYC68F0095Accident · No injuriesClosedMeyers 200-C · Portland, MEAug 2, 1967 · N189M · Substantial damage NTSB NYC68A0009Accident · 4 fatalClosedPiper PA-12 · Soldier Pond, MEJul 19, 1967 · N2867M · Destroyed NTSB NYC68D0077Accident · Minor injuriesClosedCessna 172 · Millinocket, MEJul 14, 1967 · N3861L · Substantial damage NTSB NYC68A0001Accident · 5 fatalClosedRepublic RC-3 · Searsport, MEJul 2, 1967 · N6475K · Destroyed NTSB NYC68D0086Accident · Minor injuriesClosedPiper PA-28 · Lincolnville, MEJun 24, 1967 · N5194W · Substantial damage NTSB NYC68D0073Accident · No injuriesClosedCessna 150 · Presque Isle, MEJun 17, 1967 · N8208F · Substantial damage NTSB NYC68D0016Accident · Minor injuriesClosedCessna 172G · Sherman, MEJun 13, 1967 · N3653L · Substantial damage NTSB NYC67F0671Accident · No injuriesClosedCessna 172 · Caribou, MEMay 27, 1967 · N3738S · Substantial damage NTSB NYC67I0167Incident · Serious injuriesClosedBensen B8 · Deblois, MEMay 21, 1967 · NNONE · Substantial damage NTSB NYC67F0652Accident · No injuriesClosedPiper PA-22 · Old Town, MEMay 4, 1967 · N4529Z · Substantial damage NTSB NYC67D0633Accident · No injuriesClosedAeronca 65-TAC · Turner, MEApr 21, 1967 · N36857 · Substantial damage NTSB NYC67F0577Accident · No injuriesClosedPiper PA-22 · Old Town, MEApr 12, 1967 · N1402A · Substantial damage NTSB NYC67D0550Accident · No injuriesClosedTaylorcraft BC12-D · Roxbury, MEMar 19, 1967 · N43989 · Substantial damage NTSB NYC67D0549Accident · No injuriesClosedPiper PA-12 · Fairfield, MEMar 3, 1967 · N4345M · Substantial damage NTSB NYC67D0512Accident · No injuriesClosedPiper PA-28 · Old Town, MEMar 2, 1967 · N7405R · Substantial damage NTSB NYC67F0523Accident · No injuriesClosedCessna 140 · Old Town, MEFeb 17, 1967 · CF-UWH · Substantial damage NTSB NYC67F0496Accident · No injuriesClosedLuscombe 8A · Auburn, MEFeb 15, 1967 · N2984K · Substantial damage NTSB NYC67D0536Accident · No injuriesClosedCessna 180 · Greenville, MEFeb 10, 1967 · N8624X · Substantial damage NTSB NYC67F0422Accident · Minor injuriesClosedAeronca 11AC · Pittsfield, MEJan 1, 1967 · N9370E · Substantial damage NTSB NYC67F0400Accident · No injuriesClosedPiper PA-18 · Augusta, MEDec 18, 1966 · N1516A · Substantial damage NTSB NYC67F0368Accident · No injuriesClosedPiper PA-24 · Auburn, MEDec 5, 1966 · N7216P · Substantial damage NTSB NYC67F0391Accident · No injuriesClosedPiper J3C-65 · Farmington, MEDec 4, 1966 · N25972 · Substantial damage NTSB NYC67A0069Accident · 2 fatalClosedCessna 180 · Greenville, MEOct 28, 1966 · N5278E · Destroyed NTSB NYC67A0068Accident · Minor injuriesClosedCessna 182F · Augusta, MEOct 27, 1966 · N3517U · Substantial damage NTSB NYC67F0298Accident · No injuriesClosedPiper PA-30 · Augusta, MEOct 14, 1966 · N7106Y · Substantial damage NTSB NYC67F0263Accident · No injuriesClosedPiper PA-28 · Etna, MEOct 8, 1966 · N7565W · Substantial damage NTSB NYC67F0281Accident · Minor injuriesClosedPiper PA-22 · Sinclair, MESep 29, 1966 · N6900B · Destroyed NTSB NYC67D0243Accident · No injuriesClosedCessna 172 · Sunset, MEAug 31, 1966 · N4213L · Substantial damage NTSB NYC67D0186Accident · Minor injuriesClosedCessna 195 · Naples, MEAug 21, 1966 · N4745G · Substantial damage NTSB NYC67D0232Accident · No injuriesClosedPiper J3C-65 · Nahmakanta Lak, MEAug 12, 1966 · N20246 · Substantial damage NTSB NYC67F0147Accident · No injuriesClosedCessna 180F · West Dover, MEAug 7, 1966 · N1810 · Substantial damage NTSB NYC67D0185Accident · No injuriesClosedCessna 170 · Mexico, MEAug 6, 1966 · N2554V · Substantial damage NTSB NYC67F0104Accident · No injuriesClosedCessna 310F · Augusta, MEAug 3, 1966 · N6754X · Substantial damage NTSB NYC67F0148Accident · No injuriesClosedPiper PA-28 · Biddeford, MEJul 30, 1966 · N8514W · Substantial damage NTSB NYC67F0087Accident · No injuriesClosedCessna 205 · Kingfield, MEJul 17, 1966 · N1820Z · Substantial damage NTSB NYC67F0073Accident · No injuriesClosedCessna 150 · Scarboro, MEJul 17, 1966 · N6508T · Substantial damage NTSB NYC67D0103Accident · No injuriesClosedCessna 185 · Millinocket, MEJul 13, 1966 · N2568Z · Substantial damage NTSB NYC67F0086Accident · No injuriesClosedPiper PA-28 · Winterport, MEJul 11, 1966 · N6910W · Substantial damage NTSB NYC67F0032Accident · No injuriesClosedPiper J365 · Ft Kent, MEJul 10, 1966 · N30779 · Substantial damage NTSB NYC67D0180Accident · No injuriesClosedErco 415-C · Sanford, MEJul 10, 1966 · N99158 · Substantial damage NTSB NYC67D0063Accident · No injuriesClosedPiper PA-22 · Bristol, MEJul 7, 1966 · N5528Z · Substantial damage NTSB NYC67F0072Accident · No injuriesClosedPiper PA-30 · Auburn, MEJul 1, 1966 · N7673Y · Substantial damage NTSB NYC66A0143Accident · 2 fatalClosedCessna 180 · Onawa, MEJun 6, 1966 · N2165Z · Destroyed NTSB NYC67D0121Accident · No injuriesClosedPiper PA-18 · Greenville, MEMay 4, 1966 · CF-KLL · Substantial damage