NTSB investigations, 2019, 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.

Cases per year

19622026
NTSB investigations, 2019, ME per year, 1962–2026: 1,006 cases
19621
196427
196519
196634
196729
196838
196917
197013
197128
197240
197332
197423
197525
197626
197732
197825
197927
198021
198117
198218
198317
198422
198515
198616
198714
198815
198916
199012
199119
199220
199322
199419
199512
199614
19977
199810
199913
200012
200115
200210
200310
200412
20059
200614
20079
200813
200914
201010
201116
201211
20138
20148
20154
20167
20178
20184
201911
20206
20213
20225
20236
20249
20258
20269

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'
  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 ENG20IA005Incident · No injuriesClass 3 · IncidentFinal reportAgusta A109 · Penobscot, MEFatigue fracture of the main rotor blade tip cap leading edge and subsequent partial separation of the tip cap, resulting in increased vibrations in the main rotor.Nov 16, 2019 · N901EM · Minor damageNTSB 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 CEN19LA204Accident · No injuriesClass 3 · LimitedFinal reportWaco YMF-5C · Bar Harbor, MEA total loss of engine power due to a cylinder failure for undetermined reasons.Jun 22, 2019 · N63WC · 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 damageNTSB GAA19CA213Accident · Minor injuriesData collectionFinal reportCessna 152 · Bangor, METhe pilot's improper landing flare, which resulted in a hard landing.Apr 14, 2019 · N4916B · Substantial damageNTSB DCA19FA089Accident · Minor injuriesClass 3 · FieldFinal reportEmbraer EMB145 · Presque Isle, METhe flight crew’s decision, due to confirmation bias, to continue the descent below the decision altitude when the runway had not been positively identified. Contributing to the accident were (1) the first officer’s fatigue, which exacerbated his confirmation…Mar 4, 2019 · N14171 · Substantial damage