Skip to content

NTSB investigations, ME

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 NYC79DNC08Accident · Minor injuriesClosedCessna 180 · Mt Katahdin, MENov 4, 1978 · N5094E · Substantial damage NTSB NYC78FNC51Accident · Serious injuriesClosedCessna 172M · Old Town, MESep 17, 1978 · N9604H · No damage NTSB NYC78DNC50Accident · No injuriesClosedCessna 152 · Waterville, MESep 6, 1978 · N69019 · Substantial damage NTSB NYC78DNC49Accident · No injuriesClosedPiper PA-28 · Dexter, MESep 4, 1978 · N6910W · Substantial damage NTSB NYC78FA082Accident · 1 fatalClosedCessna 150L · Prospect Harbr, MEAug 20, 1978 · N10391 · Destroyed NTSB NYC78FGM46Accident · No injuriesClosedCessna 172 · Greenville, MEAug 18, 1978 · N9921Q · Substantial damage NTSB NYC78FNC44Accident · No injuriesClosedCessna 150 · Auburn, MEJul 30, 1978 · N65671 · Substantial damage NTSB NYC78FNC38Accident · Serious injuriesClosedPiper J3F-65 · Houlton, MEJul 7, 1978 · N21828 · Substantial damage NTSB NYC78FNC35Accident · No injuriesClosedPiper PA-28 · Swans Island, MEJun 25, 1978 · N5567U · Substantial damage NTSB NYC78DNC34Accident · No injuriesClosedBoeing A75 · Jay, MEJun 25, 1978 · N1153V · Substantial damage NTSB NYC78FNC33Accident · Minor injuriesClosedTaylorcraft BC-12D · Scarboro, MEJun 24, 1978 · N47893 · Destroyed NTSB NYC78FNC30Accident · Minor injuriesClosedGrumman AA-1B · Wiscasset, MEJun 10, 1978 · N8993L · Substantial damage NTSB NYC78DNC29Accident · No injuriesClosedChampion 7ECA · Piscataquis, MEJun 2, 1978 · N6364N · Substantial damage NTSB NYC78FA054Accident · 4 fatalClosedCessna 402B · Trenton, MEMay 16, 1978 · N98720 · Destroyed NTSB NYC78FNC25Accident · No injuriesClosedGlobe GC-1B · Rockport, MEMay 14, 1978 · N3704K · Substantial damage NTSB NYC78FNC23Accident · No injuriesClosedCessna 180J · Augusta, MEApr 18, 1978 · N573JF · Substantial damage NTSB NYC78FA035Accident · 4 fatalClosedBeech S35 · Carrabassett, MEMar 19, 1978 · N5789K · Destroyed NTSB NYC78FNC17Accident · No injuriesClosedCessna 31OJ · Bangor, MEFeb 27, 1978 · N3107L · Substantial damage NTSB NYC78FNC14Accident · 2 fatalClosedCessna 150K · Dexter, MEFeb 12, 1978 · N5802G · Substantial damage NTSB NYC78FNC15Accident · No injuriesClosedChampion 7ECA · Newport, MEFeb 11, 1978 · N11075 · Substantial damage NTSB NYC78FNC13Accident · No injuriesClosedErco 415C · Biddeford, MEFeb 5, 1978 · N87194 · Substantial damage NTSB NYC78DNC12Accident · No injuriesClosedCessna 172 · Wayne, MEJan 28, 1978 · N8818B · Substantial damage NTSB NYC78DNC11Accident · No injuriesClosedCessna 172M · Harbor, MEDec 19, 1977 · N13144 · Substantial damage NTSB NYC78FA012Accident · 2 fatalClosedTaylorcraft BC12-D · Mercer, MEDec 4, 1977 · N6607N · Destroyed NTSB NYC78FNC04Accident · No injuriesClosedRepublic UC1 · Harbor, MEOct 14, 1977 · N9506U · Substantial damage NTSB NYC78FNC01Accident · No injuriesClosedPiper PA-20 · Norridgewock, MEOct 2, 1977 · N7623K · Substantial damage NTSB NYC77DNC56Accident · No injuriesClosedCessna 172 · Brunswick, MESep 22, 1977 · N7919G · Substantial damage NTSB NYC77FNC55Accident · No injuriesClosedStinson 108-3 · Saco, MESep 11, 1977 · N6678M · Substantial damage NTSB NYC77FA096Accident · 1 fatalClosedLake LA-4 · Greenville, MESep 10, 1977 · N1095L · Destroyed NTSB NYC77FNC52Accident · No injuriesClosedPiper PA-20 · Thomaston, MEAug 31, 1977 · N7309K · Substantial damage NTSB NYC77FNC51Accident · Minor injuriesClosedCessna A185E · Patten, MEAug 29, 1977 · N4569F · Substantial damage NTSB NYC77DNC49Accident · Minor injuriesClosedCessna 177 · Hope, MEAug 28, 1977 · N3366T · Substantial damage NTSB NYC77FNC53Accident · No injuriesClosedTaylorcraft BC-65 · West Lebanon, MEAug 27, 1977 · N24046 · Substantial damage NTSB NYC77DNC47Accident · No injuriesClosedCessna 150 · Belfast, MEAug 15, 1977 · N6626G · Destroyed NTSB NYC77FNC46Accident · No injuriesClosedStearman C3-R · Rockland, MEAug 13, 1977 · N799H · Substantial damage NTSB NYC77FNC45Accident · No injuriesClosedCessna 120 · Limerick, MEAug 9, 1977 · N1946N · Substantial damage NTSB NYC77DNC44Accident · No injuriesClosedCessna 337 · Bingham, MEAug 6, 1977 · N1871M · Substantial damage NTSB NYC77FNC43Accident · 1 fatalClosedBellanca 7GCBC · Ft Fairfield, MEAug 2, 1977 · N57482 · Destroyed NTSB NYC77FNC41Accident · No injuriesClosedCessna 150H · Standish, MEJul 27, 1977 · N23422 · Substantial damage NTSB NYC77FA073Accident · No injuriesClosedPiper PA-23 · Rockland, MEJul 25, 1977 · N594DE · Substantial damage NTSB NYC77DNC42Accident · No injuriesClosedPiper PA-28 · Old Town, MEJul 22, 1977 · N7882C · Substantial damage NTSB NYC77FNC37Accident · Serious injuriesClosedCessna 150K · Waldoboro, MEJun 15, 1977 · N6354G · Substantial damage NTSB NYC77DNC33Accident · No injuriesClosedCessna 172 · Vinalhaven, MEMay 28, 1977 · N1738V · Substantial damage NTSB NYC77FA062Accident · 3 fatalClosedCessna 182F · Oxbow, MEMay 26, 1977 · N3148U · Substantial damage NTSB NYC77FNC31Accident · No injuriesClosedCessna 172N · Princeton, MEMay 19, 1977 · N75540 · Substantial damage NTSB NYC77DNC28Accident · Minor injuriesClosedPiper PA-22 · Montville, MEMay 1, 1977 · N3412A · Destroyed NTSB NYC77DNC26Accident · Minor injuriesClosedCessna 150M · Richmond Is, MEApr 22, 1977 · N66064 · Substantial damage NTSB NYC77DNC27Accident · No injuriesClosedPiper PA-34 · Presque Isle, MEApr 15, 1977 · N33723 · Substantial damage NTSB NYC77DNC24Accident · No injuriesClosedBeech B19 · Machias, MEApr 11, 1977 · N24605 · Substantial damage NTSB NYC77FNC23Accident · No injuriesClosedCessna 182P · Stonington, MEApr 8, 1977 · N6067F · Substantial damage