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 NYC77DNC21Accident · No injuriesClosedCessna 414 · Carabasset, MEFeb 14, 1977 · N5264J · Substantial damage NTSB NYC77FNC17Accident · Serious injuriesClosedCessna 172 · Caribu, MEJan 13, 1977 · N7138Q · Substantial damage NTSB NYC77DNC18Accident · No injuriesClosedCessna 172 · Abbott Village, MEJan 6, 1977 · N12734 · Substantial damage NTSB NYC77DNC15Accident · No injuriesClosedPiper PA-28 · Bar Harbor, MEJan 2, 1977 · N8388C · Substantial damage NTSB NYC77IA025Incident · No injuriesClosedBoeing 727 · Bangor, MEDec 27, 1976 · N473DA · Minor damage NTSB NYC77FNC13Accident · Serious injuriesClosedPiper PA-18 · Millinocket, MEDec 16, 1976 · N1340A · Destroyed NTSB NYC77DNC12Accident · No injuriesClosedBeech C23 · Frenchville, MEDec 16, 1976 · N2054L · Substantial damage NTSB NYC77DNC11Accident · Serious injuriesClosedPiper PA-22 · Newburgh, MEDec 10, 1976 · C-GLCK · Substantial damage NTSB NYC77FNC09Accident · No injuriesClosedPiper PA-18 · Bangor, MENov 10, 1976 · N1617A · Substantial damage NTSB NYC77DNC07Accident · No injuriesClosedCessna 185 · Newport, MENov 3, 1976 · N1517F · Substantial damage NTSB NYC77FNC06Accident · Minor injuriesClosedCessna 150M · Cherryfield, MENov 2, 1976 · N760CA · Substantial damage NTSB NYC77DNC05Accident · No injuriesClosedCessna 150J · Howland, MEOct 30, 1976 · N5584G · Substantial damage NTSB NYC77DNC03Accident · No injuriesClosedPiper PA-24 · Bangor, MEOct 22, 1976 · CF-NVO · Substantial damage NTSB NYC77FNC01Accident · No injuriesClosedCessna 172M · Greenville, MEOct 7, 1976 · N13339 · Substantial damage NTSB NYC76FNC67Accident · No injuriesClosedPiper PA-11 · Cushing, MESep 30, 1976 · N4891M · Substantial damage NTSB NYC76DNC66Accident · Serious injuriesClosedTaylorcraft BC12-D · Norridgewock, MESep 22, 1976 · N44444 · Substantial damage NTSB NYC76AN122Accident · Minor injuriesClosedBeech 99 · Ellsworth, MEAug 16, 1976 · N200WP · Destroyed NTSB NYC76DNC64Accident · Minor injuriesClosedCessna 172 · Andover, MEAug 15, 1976 · N13325 · Destroyed NTSB NYC76FNC62Accident · No injuriesClosedPiper PA-28 · Bethel, MEAug 8, 1976 · N8630D · Substantial damage NTSB NYC76FNC56Accident · No injuriesClosedPiper J5A · Camden, MEJul 11, 1976 · N38633 · Substantial damage NTSB NYC76FNC55Accident · No injuriesClosedBoeing A75N1 · Belmont, MEJul 10, 1976 · N70043 · Destroyed NTSB NYC76FNC53Accident · No injuriesClosedPiper PA-28 · Hollis Center, MEJul 6, 1976 · N8400R · Substantial damage NTSB NYC76DNC51Accident · No injuriesClosedCessna A185F · Bangor, MEMay 29, 1976 · N3478Y · Substantial damage NTSB NYC76FNC50Accident · Serious injuriesClosedCessna 177 · Swans Island, MEMay 16, 1976 · N3254T · Substantial damage NTSB NYC76FFA48Accident · No injuriesClosedPiper PA-28 · Blue Hill, MEMay 5, 1976 · N3844T · Destroyed NTSB NYC76AN092Accident · 1 fatalClosedPiper PA-24 · Orrington, MEApr 17, 1976 · N6904P · Substantial damage NTSB NYC76FNC39Accident · No injuriesClosedCessna 120 · Wiscasset, MEApr 14, 1976 · N89925 · Substantial damage NTSB NYC76DNC38Accident · No injuriesClosedCessna 150 · Lincoln, MEApr 6, 1976 · N3254J · Substantial damage NTSB NYC76FNC41Accident · Minor injuriesClosedCessna 180 · Gray, MEFeb 7, 1976 · N9354T · Substantial damage NTSB NYC76AN068Accident · 1 fatalClosedPiper PA-28R · Auburn, MEJan 24, 1976 · N2074T · No damage NTSB NYC76DNC31Accident · No injuriesClosedCessna 150 · Turner, MENov 19, 1975 · N6896G · Substantial damage NTSB NYC76DNC29Accident · Minor injuriesClosedPiper PA-28 · Wiscasset, MENov 9, 1975 · N4299T · Substantial damage NTSB NYC76DNC26Accident · No injuriesClosedPiper PA-18 · Brooklin, MEOct 19, 1975 · N7068D · Substantial damage NTSB NYC76FNC22Accident · No injuriesClosedCessna 150 · Turner, MEOct 3, 1975 · N7066S · Substantial damage NTSB NYC76DNC21Accident · Minor injuriesClosedPiper PA-18 · Greenville, MESep 25, 1975 · N3690A · Substantial damage NTSB NYC76FNC20Accident · Minor injuriesClosedBeech B19 · Greenville, MESep 11, 1975 · N6556R · Substantial damage NTSB NYC76FNC16Accident · No injuriesClosedCessna 180 · Rangeley, MESep 7, 1975 · N1539C · Substantial damage NTSB NYC76DNC17Accident · No injuriesClosedCessna 150L · Bangor, MESep 5, 1975 · N11196 · Substantial damage NTSB NYC76FNC13Accident · Minor injuriesClosedStinson 10A · Northport, MEAug 21, 1975 · N31586 · Destroyed NTSB NYC76DNC11Accident · No injuriesClosedAeronca 11AC · Chebeague Is, MEAug 19, 1975 · N86175 · Substantial damage NTSB NYC76AN024Accident · No injuriesClosedBoeing 727 · Portland, MEAug 16, 1975 · N468D · Substantial damage NTSB NYC76FNC09Accident · No injuriesClosedPiper PA-30 · Brewer, MEAug 13, 1975 · N7524Y · Substantial damage NTSB NYC76DNC08Accident · Minor injuriesClosedStinson 108 · Bangor, MEAug 10, 1975 · N9368K · Substantial damage NTSB NYC76DNC05Accident · Minor injuriesClosedCessna 140A · Portage, MEAug 3, 1975 · N9400A · Substantial damage NTSB NYC76FNC04Accident · 1 fatalClosedCessna 172M · Dexter, MEAug 1, 1975 · N13272 · Substantial damage NTSB NYC76AN016Accident · Minor injuriesClosedAero Comdr 500 · Baxter St Pk, MEJul 26, 1975 · N6283B · Substantial damage NTSB NYC76DNC01Accident · No injuriesClosedTaylorcraft BC12-D · Caribou, MEJul 13, 1975 · N43875 · Substantial damage NTSB NYC75FNC40Accident · No injuriesClosedBenson B8M · Biddeford, MEJun 28, 1975 · N3979 · Substantial damage NTSB NYC75AN114Accident · Minor injuriesClosedCessna 180 · Greenville, MEJun 1, 1975 · N8626X · Substantial damage NTSB NYC75FNC35Accident · Minor injuriesClosedGrumman TBM-3E · Millinocket, MEMay 29, 1975 · N4168A · Destroyed