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 NYC75FNC32Accident · Serious injuriesClosedPiper PA-32 · Frankfort, MEMay 13, 1975 · N56012 · Destroyed NTSB NYC75FNC30Accident · No injuriesClosedHelio Acft H-391B · Bar Harbor, MEApr 23, 1975 · N4141D · Substantial damage NTSB NYC75DNC27Accident · No injuriesClosedCessna 172 · Rockland, MEMar 31, 1975 · N8436L · Substantial damage NTSB NYC75AN092Accident · 1 fatalClosedLuscombe 8E · Rumford, MEMar 16, 1975 · N1540K · Substantial damage NTSB NYC75DNC24Accident · No injuriesClosedCessna 180 · Otter Pond, MEFeb 8, 1975 · N9CG · Substantial damage NTSB NYC75AN075Accident · Minor injuriesClosedCessna 182 · Vinalhaven, MEDec 23, 1974 · N8818T · Substantial damage NTSB NYC75FNC21Accident · Serious injuriesClosedPiper PA-24 · Augusta, MEDec 16, 1974 · N8726P · Substantial damage NTSB NYC75DNC19Accident · Minor injuriesClosedLake LA-4 · Round Pond, MENov 14, 1974 · N39797 · Substantial damage NTSB NYC75AN058Accident · 3 fatalClosedCessna 172 · Bridgewater, MENov 6, 1974 · N19927 · Destroyed NTSB NYC75AN056Accident · Minor injuriesClosedPiper PA-18 · Patten, MENov 3, 1974 · N3696Z · Substantial damage NTSB NYC75FNC17Accident · Serious injuriesClosedBeech A24R · Augusta, MEOct 29, 1974 · N9704Q · Destroyed NTSB NYC75FNC16Accident · No injuriesClosedCessna 150J · Wiscasset, MEOct 24, 1974 · N50899 · Substantial damage NTSB NYC75DNC11Accident · Minor injuriesClosedErco 415-D · Cambridge, MESep 29, 1974 · N1084 · Substantial damage NTSB NYC75DNC10Accident · No injuriesClosedCessna 150 · Old Town, MESep 24, 1974 · N18147 · Substantial damage NTSB NYC75AN026Accident · 1 fatalClosedEnstrom F-28A · S Casco, MEAug 31, 1974 · N29HW · Destroyed NTSB NYC75FNC05Accident · Minor injuriesClosedPiper PA-16 · Bowdoinham, MEJul 16, 1974 · N5260H · Substantial damage NTSB NYC75DNC03Accident · Minor injuriesClosedAmer Avco AA1-A · Bowdoinham, MEJul 14, 1974 · N9362L · Substantial damage NTSB NYC75FNC06Accident · No injuriesClosedPiper PA-23 · Pittsfield, MEJul 10, 1974 · N6365Y · Substantial damage NTSB NYC75FNC01Accident · Serious injuriesClosedAeronca 11AC · Lyman, MEJul 4, 1974 · N9111E · Substantial damage NTSB NYC74DNC49Accident · No injuriesClosedAeronca 7DC · Winterport, MEJun 23, 1974 · N84775 · Destroyed NTSB NYC74DNC46Accident · No injuriesClosedChampion 7ECA · N.Canada Plant, MEJun 8, 1974 · N5139G · Substantial damage NTSB NYC74DNC44Accident · No injuriesClosedPiper PA-18 · Winslow, MEMay 19, 1974 · N1473C · Substantial damage NTSB NYC74FNC40Accident · Serious injuriesClosedLuscombe 8A · Gray, MEApr 25, 1974 · N25237 · Destroyed NTSB NYC74AN090Accident · 1 fatalClosedCessna 150 · Boothbay Harbr, MEApr 22, 1974 · N50819 · Substantial damage NTSB NYC74AN068Accident · 1 fatalClosedCessna 172M · Otis, MEFeb 7, 1974 · N3527Q · Destroyed NTSB NYC74FNC36Accident · No injuriesClosedCessna 150 · Eliot, MEJan 20, 1974 · N18585 · Substantial damage NTSB NYC74DNC33Incident · No injuriesClosedPiper PA-32 · Frenchville, MEJan 7, 1974 · N4188R · Minor damage NTSB NYC74FNC32Accident · Minor injuriesClosedCessna 150G · Belfast, MEJan 4, 1974 · N3402J · Substantial damage NTSB NYC74FNC31Accident · Serious injuriesClosedCessna 172M · Rangeley, MENov 19, 1973 · N92899 · Destroyed NTSB NYC74FNC28Accident · Minor injuriesClosedBowers Fly Baby · South Paris, MEOct 28, 1973 · NONE · Substantial damage NTSB NYC74AN042Accident · 2 fatalClosedPiper PA-28 · Allagash, MEAug 25, 1973 · CF-TEN · Destroyed NTSB NYC74DNC17Accident · No injuriesClosedCessna 150G · Wiscasset, MEAug 17, 1973 · N8556J · Substantial damage NTSB NYC74FNC14Accident · Serious injuriesClosedTaylorcraft BC12-D · Greenville, MEAug 12, 1973 · N39271 · Destroyed NTSB NYC74AN011Accident · No injuriesClosedCessna 402 · Bar Harbor, MEAug 2, 1973 · N4526Q · Substantial damage NTSB NYC74DNC11Accident · Minor injuriesClosedPiper PA-22 · Lubec, MEJul 30, 1973 · N3662P · Substantial damage NTSB NYC74DNC13Accident · Minor injuriesClosedAmer Avco AA-1A · Alton, MEJul 25, 1973 · N6379L · Substantial damage NTSB NYC74FNC12Accident · No injuriesClosedLake LA-4 · Bethel, MEJul 22, 1973 · N1127L · Substantial damage NTSB NYC74DNC09Accident · No injuriesClosedCessna 180 · Greenville, MEJul 19, 1973 · N8213V · Substantial damage NTSB NYC74FNC06Accident · No injuriesClosedLuscombe 8F · Trenton, MEJul 14, 1973 · N9903C · Substantial damage NTSB NYC74DNC07Accident · Minor injuriesClosedBell 47G · Weld, MEJul 13, 1973 · N950B · Substantial damage NTSB NYC74FNC03Accident · No injuriesClosedBoeing A75 · South Hope, MEJul 9, 1973 · N9215H · Substantial damage NTSB NYC74FNC02Accident · Serious injuriesClosedPiper PA-28 · Buxton, MEJul 8, 1973 · N6349J · Substantial damage NTSB NYC74FNC01Accident · 1 fatalClosedSnow 600S2C · Presque Isle, MEJul 6, 1973 · N9472R · Substantial damage NTSB NYC73AN155Accident · 2 fatalClosedPiper PA-23 · Princeton, MEJun 22, 1973 · N157TD · Destroyed NTSB NYC73AN153Accident · Serious injuriesClosedDouglas DC-8 · Bangor, MEJun 20, 1973 · N863F · Minor damage NTSB NYC73DNG75Accident · No injuriesClosedGrumman TBM-3E · Fort Kent, MEJun 4, 1973 · N7014C · Substantial damage NTSB NYC73FNC73Accident · No injuriesClosedPiper J3-65 · Augusta, MEMay 26, 1973 · N42571 · Substantial damage NTSB NYC73AN141Accident · 6 fatalClosedCessna 402B · Greenville, MEMay 11, 1973 · N2985Q · Destroyed NTSB NYC73FNC69Accident · No injuriesClosedCessna 150 · Norridgewock, MEApr 15, 1973 · N4024U · Substantial damage NTSB NYC73DNC70Accident · Minor injuriesClosedLuscombe 8A · Princeton, MEApr 15, 1973 · N2209K · Substantial damage