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 NYC72FNC16Accident · No injuriesClosedPiper J3C-65 · East Dixfield, MEDec 5, 1971 · N98462 · Substantial damage NTSB NYC72FNC19Accident · Minor injuriesClosedErco 415-CD · Pownal, MENov 28, 1971 · N3777H · Substantial damage NTSB NYC72FNC12Accident · No injuriesClosedTaylorcraft BC12-D · Frye, MEOct 20, 1971 · N23648 · Substantial damage NTSB NYC72AN037Accident · 4 fatalClosedMooney M20E · Bryant Pond, MESep 7, 1971 · N79336 · Destroyed NTSB NYC72FNC10Accident · Serious injuriesClosedRaven S-40A · Blue Hill, MESep 6, 1971 · N1924R · Substantial damage NTSB NYC72AN022Accident · 3 fatalClosedPiper PA-31 · Augusta, MEAug 19, 1971 · N595DE · Destroyed NTSB NYC72FNC09Accident · No injuriesClosedPiper PA-23 · Old Town, MEAug 16, 1971 · N5195Y · Substantial damage NTSB NYC72DNC08Accident · No injuriesClosedPiper PA-28 · Limestone, MEAug 2, 1971 · N98384 · Substantial damage NTSB NYC72AN017Accident · Serious injuriesClosedCessna 180 · Greenville, MEJul 31, 1971 · N2481F · Substantial damage NTSB NYC72AN016Accident · 1 fatalClosedGrumman G-21A · Greenville, MEJul 30, 1971 · N101LH · Destroyed NTSB NYC72FNC04Accident · Minor injuriesClosedPiper PA-18S · Auburn, MEJul 15, 1971 · N2993Z · Substantial damage NTSB NYC72FNC03Accident · No injuriesClosedCessna 150 · Anson, MEJul 4, 1971 · N22867 · Substantial damage NTSB NYC72ENC02Accident · No injuriesClosedBensen BM-8M · Steuben, MEJul 4, 1971 · N1479 · Destroyed NTSB NYC71IN121Incident · No injuriesClosedBell 47G-2 · Greenville, MEJun 17, 1971 · N2805B · Minor damage NTSB NYC71FNC32Accident · Minor injuriesClosedTaylorcraft DCO-65 · Gorham, MEJun 17, 1971 · N46260 · Destroyed NTSB NYC71DNC31Accident · No injuriesClosedAeronca 7DC · Berwick, MEJun 7, 1971 · N82439 · Substantial damage NTSB NYC71FNC28Accident · No injuriesClosedCessna U206 · Bridgton, MEMay 17, 1971 · N2186F · Substantial damage NTSB NYC71DNC26Accident · No injuriesClosedCessna 180 · Baring, MEApr 23, 1971 · N2926A · Substantial damage NTSB NYC71FNC22Accident · Minor injuriesClosedCessna 182B · Mexico, MEApr 12, 1971 · N2566G · Substantial damage NTSB NYC71FNC21Accident · Minor injuriesClosedCessna 120 · Old Town, MEApr 11, 1971 · N3138N · Substantial damage NTSB NYC71FNC20Accident · No injuriesClosedPiper PA-22 · Woolwich, MEApr 2, 1971 · N4724Z · Substantial damage NTSB NYC71FFG19Accident · No injuriesClosedChampion 7ECA · Pittsfield, MEMar 28, 1971 · N6324N · Substantial damage NTSB NYC71FFG18Accident · No injuriesClosedCessna 150G · Turner, MEMar 26, 1971 · N3604J · Substantial damage NTSB NYC71DFG17Accident · No injuriesClosedPiper PA-22 · Caribou, MEMar 10, 1971 · N7304D · Substantial damage NTSB NYC71FFG15Accident · Minor injuriesClosedCessna 310N · Auburn, MEJan 19, 1971 · N5046Q · Substantial damage NTSB NYC71FFG13Accident · No injuriesClosedErco 415C · North Berwick, MEJan 17, 1971 · N3777H · Substantial damage NTSB NYC71DFG12Accident · No injuriesClosedPiper PA-28 · Belfast, MEJan 10, 1971 · N8870N · Substantial damage NTSB NYC71FFG11Accident · No injuriesClosedPiper PA-28R · Portland, MEJan 9, 1971 · N3298R · Substantial damage NTSB NYC71FFG09Accident · No injuriesClosedCessna 185 · Portland, MEDec 27, 1970 · N4710 · Substantial damage NTSB NYC71FFG04Accident · No injuriesClosedCessna 140 · Norridgewock, MESep 14, 1970 · N3650V · Substantial damage NTSB NYC71DFG06Accident · No injuriesClosedPiper PA-18 · Sebago Lake, MESep 5, 1970 · N7501K · Destroyed NTSB NYC71FFG03Accident · No injuriesClosedCessna 150G · Washburn, MEAug 13, 1970 · N8550J · Substantial damage NTSB NYC71DFG01Accident · Minor injuriesClosedPiper PA-20 · Pittsfield, MEAug 5, 1970 · N8869C · Substantial damage NTSB NYC71AN001Accident · 1 fatalClosedPiper PA-24 · Mount Desert, MEJun 30, 1970 · N9349P · Destroyed NTSB NYC70AN128Accident · Serious injuriesClosedDouglas DC-8F · Bangor, MEJun 9, 1970 · N8787R · Minor damage NTSB NYC70FFG08Accident · Serious injuriesClosedDart GK-19 · Berwick, MEMay 3, 1970 · N20910 · Substantial damage NTSB NYC70FFG07Accident · Minor injuriesClosedKonecki ACE · Lewiston, MEMay 2, 1970 · N391JK · Substantial damage NTSB NYC70FFG04Accident · Serious injuriesClosedCessna 190 · Pownal, MEMar 22, 1970 · N4314N · Substantial damage NTSB NYC70FFG05Accident · Serious injuriesClosedTaylorcraft BC12-D · Stratton, MEMar 20, 1970 · N96628 · Destroyed NTSB NYC70FFG02Accident · No injuriesClosedErco 415-C · Winthrop, MEJan 24, 1970 · N2306H · Substantial damage NTSB NYC70FFG01Accident · Serious injuriesClosedTaylorcraft BL-12 · West Paris, MEJan 17, 1970 · N24321 · Destroyed NTSB NYC70A0061Accident · 3 fatalClosedPiper PA-23 · Passadumkeag, MEDec 10, 1969 · N5090Y · Destroyed NTSB NYC70D0214Accident · Minor injuriesClosedPiper PA-28 · Pittsfield, MENov 24, 1969 · N7577R · Substantial damage NTSB NYC70F0207Accident · No injuriesClosedPiper PA-12S · Raymond, MENov 15, 1969 · N3932M · Destroyed NTSB NYC70D0169Accident · No injuriesClosedCessna 150F · New Sharon, MEOct 12, 1969 · N8411G · Substantial damage NTSB NYC70D0157Accident · No injuriesClosedAero Comdr 720 · Loring Afb, MESep 4, 1969 · CF-SJA · Substantial damage NTSB NYC70A0019Accident · 1 fatalClosedCessna 180B · Greenville, MEAug 5, 1969 · N5084E · Substantial damage NTSB NYC70D0009Accident · No injuriesClosedCessna 150F · Caribou, MEJun 11, 1969 · N8208F · Substantial damage NTSB NYC69F0386Accident · No injuriesClosedCessna 140 · Biddeford, MEApr 30, 1969 · N76527 · Substantial damage NTSB NYC69A0094Accident · No injuriesClosedPiper PA-23 · Portland, MEApr 18, 1969 · N5090Y · Substantial damage