NTSB investigations, 2019, ME

7 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2019, ME per year, 2008–2026: 61 cases
20083
20092
20106
201110
20128
20133
20144
20162
20175
20181
20197
20221
20232
20243
20252
20262

Latest cases

Query with SQL
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 year(c.\"eventDate\") = 2019
    AND c.\"eventStateOrRegion\" = 'ME' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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.

NTSB ERA19LA287Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R44 · Sanford, METhe student pilot's failure to maintain helicopter control while hover-taxiing in gusting wind conditions.Sep 28, 2019 · N21EH · Substantial damageNTSB GAA19CA513Accident · Minor injuriesData collectionFinal reportCessna A185 · Rangeley Lake, METhe pilot's inadequate preflight inspection of the floats, which led to his subsequent attempt to depart from a lake with damaged floats and led to a loss of roll control and the right wing impacting the water.Aug 22, 2019 · N1920Q · Substantial damageNTSB GAA19CA425Accident · No injuriesData collectionFinal reportAeros Skyranger · Brownville, METhe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent loss of directional control while attempting a go-around, which resulted in a runway excursion and impact with trees.Jul 16, 2019 · N75561 · Substantial damageNTSB GAA19CA407Accident · No injuriesData collectionFinal reportCessna 172 · Montville, METhe pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle of attack during a low-altitude climbing turn, which resulted in an aerodynamic stall.Jul 3, 2019 · N1516E · Substantial damageNTSB GAA19CA350Accident · No injuriesData collectionFinal reportPiper PA28 · Nowdoinham, METhe flight instructor's delayed decision to abort the takeoff from a wet, grass runway with insufficient runway remaining, which resulted in a runway overrun and the airplane going down an embankment.Jun 7, 2019 · N7227F · Substantial damageNTSB GAA19CA320Accident · No injuriesData collectionFinal reportCessna A185 · Ashland, METhe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with a tree.Jun 7, 2019 · N484RF · Substantial damageNTSB GAA19CA214Accident · No injuriesData collectionFinal reportCessna 180 · Limington, METhe pilot's failure to maintain directional control during touchdown, which resulted in runway excursion onto snow.Apr 14, 2019 · N4796B · Substantial damage