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 NYC80FNC47Accident · No injuriesClosedCessna 180H · Livermore, MESep 25, 1980 · N3426Y · Substantial damage NTSB NYC80FNC44Accident · No injuriesClosedCessna 150 · Rangeley, MEAug 30, 1980 · N63670 · Substantial damage NTSB NYC80FNC43Accident · Serious injuriesClosedBellanca 7ECA · Milbridge, MEAug 25, 1980 · N11685 · Destroyed NTSB NYC80FNC35Accident · No injuriesClosedChampion 7ECA · Scarborough, MEJul 26, 1980 · N2830G · Substantial damage NTSB NYC80FNC34Accident · Minor injuriesClosedPiper PA-25 · Franklin, MEJul 24, 1980 · N8529L · Substantial damage NTSB NYC80FNC33Accident · No injuriesClosedCessna 172 · Turner, MEJul 8, 1980 · N9931Q · Substantial damage NTSB NYC80FNC31Accident · No injuriesClosedSikorsky S-58T · Bangor, MEJul 1, 1980 · N870 · Substantial damage NTSB NYC80FNC30Accident · No injuriesClosedBellanca 7GCAA · Biddeford, MEJul 1, 1980 · N86701 · Substantial damage NTSB NYC80FNC29Accident · No injuriesClosedCessna 170B · Norridgewock, MEJun 28, 1980 · N3112A · Substantial damage NTSB NYC80FA048Accident · Serious injuriesClosedPiper PA-18 · Patten, MEJun 25, 1980 · N1933A · Destroyed NTSB NYC80FNC28Accident · No injuriesClosedEea Biplane A · E Brownfield, MEJun 22, 1980 · N9081 · Substantial damage NTSB NYC80FA047Accident · 2 fatalClosedCessna 150G · Searsport, MEJun 18, 1980 · N2930S · Destroyed NTSB NYC80FA022Accident · 1 fatalClosedMaule 235C · Eagle Lake, MEMay 21, 1980 · N56356 · Destroyed NTSB NYC80DNC24Accident · No injuriesClosedChampion 7GCB · New Limerick, MEMay 10, 1980 · N9926Y · Substantial damage NTSB NYC80FA060Accident · 2 fatalClosedCessna 172 · Rockland, MEMar 16, 1980 · N707BB · Destroyed NTSB NYC80FNC16Accident · No injuriesClosedPiper PA-28 · Eliot, MEMar 15, 1980 · N57302 · Substantial damage NTSB NYC80FNC15Accident · Minor injuriesClosedPiper PA-28 · Portland, MEMar 13, 1980 · N1016X · Substantial damage NTSB NYC80FNC11Accident · Minor injuriesClosedCessna 150 · Augusta, MEFeb 8, 1980 · N9158U · Substantial damage NTSB NYC80FNC09Accident · No injuriesClosedCessna 150 · Sanford, MEFeb 4, 1980 · N9343U · Substantial damage NTSB NYC80FA021Accident · 2 fatalClosedPiper PA-18 · East Machias, MEJan 22, 1980 · N3580Z · Destroyed NTSB NYC80FNC05Accident · Serious injuriesClosedCessna 180 · Turner, MEDec 21, 1979 · N6417X · Substantial damage NTSB NYC80FA012Accident · Minor injuriesClosedBeech 99 · Bangor, MENov 18, 1979 · N983MA · Substantial damage NTSB NYC80FA006Accident · 1 fatalClosedPiper PA-28 · Gilead, MEOct 25, 1979 · N407FL · Substantial damage NTSB NYC80DNC02Accident · No injuriesClosedPiper PA-20 · Lakeville, MEOct 7, 1979 · N1835A · Substantial damage NTSB NYC80DNC01Accident · No injuriesClosedN. American AT-6 · Belfast, MEOct 6, 1979 · N66WP · Destroyed NTSB NYC79DNC50Accident · No injuriesClosedCessna 172 · Brewer, MESep 12, 1979 · N6754A · Substantial damage NTSB NYC79DA096Accident · No injuriesClosedCessna 172 · Greenville, MESep 10, 1979 · N12736 · Substantial damage NTSB NYC79FNC49Accident · Minor injuriesClosedPiper PA-22 · Bangor, MEAug 26, 1979 · N2508P · Substantial damage NTSB NYC79FNC48Accident · No injuriesClosedCessna 150 · Eliot, MEAug 18, 1979 · N9338U · Substantial damage NTSB NYC79DNC79Accident · No injuriesClosedPiper PA-22 · Alexander, MEAug 15, 1979 · N1437C · Substantial damage NTSB NYC79FNC45Accident · Minor injuriesClosedBenson B8MVW · Mars Hill, MEAug 4, 1979 · N1182 · Substantial damage NTSB NYC79FNC44Accident · Minor injuriesClosedCessna 180 · Greenville, MEAug 1, 1979 · N2715K · Substantial damage NTSB NYC79DNC40Accident · Minor injuriesClosedDehavilland DH82A · Pittsfield, MEJul 28, 1979 · N8872 · Substantial damage NTSB NYC79DNC38Accident · No injuriesClosedPiper PA-18 · Spruce Head, MEJul 23, 1979 · N3194Z · Substantial damage NTSB NYC79DNC37Accident · No injuriesClosedCessna 120 · Kents Hill, MEJul 20, 1979 · N3138N · Substantial damage NTSB NYC79DNC39Accident · No injuriesClosedPiper PA-18S · Jackson, MEJul 10, 1979 · N9276D · Substantial damage NTSB NYC79FNC35Accident · No injuriesClosedErco 415-C · Turner, MEJul 9, 1979 · N99249 · Substantial damage NTSB NYC79FNC33Accident · Minor injuriesClosedGreat Lakes Baby · Farmington, MEJun 29, 1979 · N34HP · Substantial damage NTSB NYC79DNC79Accident · Minor injuriesClosedPiper PA-16 · Fayette, MEJun 16, 1979 · N6831K · Substantial damage NTSB NYC79DNC29Accident · No injuriesClosedPiper J-3 · Millinocket, MEJun 9, 1979 · N23150 · Substantial damage NTSB DCA79AA018Accident · 17 fatalClosedDehavilland DHC-6 · Rockland, MEMay 30, 1979 · N68DE · Destroyed NTSB NYC79FNC27Accident · Serious injuriesClosedAeronca 7CCM · Patten, MEMay 6, 1979 · N1559E · Substantial damage NTSB NYC79FA040Accident · 1 fatalClosedLake LA-4 · Jonesboro, MEApr 20, 1979 · N7639L · Destroyed NTSB NYC79FNC24Accident · Minor injuriesClosedTaylorcraft BC-12D · Waterville, MEApr 18, 1979 · N43937 · Substantial damage NTSB NYC79FA026Accident · 2 fatalClosedCessna 172 · Poland, MEMar 3, 1979 · N738HR · Substantial damage NTSB NYC79DNC19Accident · No injuriesClosedCessna 182 · Greenville, MEFeb 21, 1979 · N5759J · Substantial damage NTSB NYC79FNC17Accident · Serious injuriesClosedPiper PA-28 · Portland, MEFeb 4, 1979 · N42236 · Substantial damage NTSB NYC79FNC12Accident · No injuriesClosedMooney M20J · Augusta, MEDec 23, 1978 · N201M · 2 aircraft · Substantial damage NTSB NYC79DNC13Accident · No injuriesClosedCessna 180 · Bangor, MENov 19, 1978 · N91470 · Substantial damage NTSB NYC79FA011Accident · 6 fatalClosedPiper PA-32 · Newry, MENov 10, 1978 · CGPJU · Destroyed