NTSB investigations, 2017, MI

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, 2017, MI per year, 1962–2026: 4,705 cases
19621
19631
1964145
1965153
1966169
1967193
1968174
1969182
1970176
1971159
1972150
1973149
1974141
1975115
1976131
1977106
1978121
1979118
198098
1981116
198287
1983101
198491
198582
198686
198757
198863
198969
199086
199165
199266
199360
199452
199556
199658
199752
199851
199950
200046
200162
200244
200350
200439
200543
200648
200736
200832
200935
201030
201134
201238
201329
201431
201526
201624
201722
201828
201923
202022
202129
202217
202321
202421
202526
202619

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\") = 2017
    AND c.\"eventStateOrRegion\" = 'MI' 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 GAA18CA097Accident · No injuriesData collectionFinal reportCessna 172 · Monroe, MIThe student pilot’s improper yaw control during the landing flare and the flight instructor’s failure to take remedial action, which resulted in a hard landing.Dec 21, 2017 · N4491R · Substantial damageNTSB DCA18CA042Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD 88 · Detroit, MIfailure of the flight crew to confirm the left engine throttle lever was at idle during engine start.Dec 12, 2017 · N924DL · Substantial damageNTSB GAA18CA081Accident · No injuriesData collectionFinal reportPiper PA 32 · Cheboygan, MIThe pilot’s failure to maintain the airplane’s rate of descent in gusting wind conditions resulting in a hard landing and runway excursion.Dec 5, 2017 · N4887S · Substantial damageNTSB GAA18CA007Accident · No injuriesData collectionFinal reportCessna T210 · Waterford, MIThe pilot's unstabilized approach at night, which resulted in collision with trees.Oct 7, 2017 · N5EC · Substantial damageNTSB CEN18FA001Accident · 1 fatalField investigationFinal reportBrantly B 2B · Midland, MIThe pilot's failure to maintain control of the helicopter, which resulted in a loss of tail rotor effectiveness, and his failure to promptly initiate the proper recovery technique, which resulted in a descent that could not be arrested before impacting the…Oct 1, 2017 · N2284U · Substantial damageNTSB CEN17FA332Accident · Serious injuriesField investigationFinal reportCessna 180J · Gaylord, MIThe pilot's failure to use carburetor heat while operating in weather conditions that were conducive to carburetor ice formation, which resulted in a total loss of engine power due to carburetor ice accumulation.Aug 28, 2017 · N180LP · Substantial damageNTSB GAA17CA485Accident · No injuriesData collectionFinal reportCessna 182 · Sparta, MIThe pilot’s improper landing flare, which resulted in a hard landing.Aug 12, 2017 · N52450 · Substantial damageNTSB CEN17LA316Accident · Serious injuriesLimited investigationFinal reportNavion Navion G · Adrian, MIA leak in the gascolator, which allowed air to enter the fuel system and resulted in a partial loss of engine power.Aug 11, 2017 · N249KC · Substantial damageNTSB GAA17CA416Accident · No injuriesData collectionFinal reportPiper PA 22 · Breckenridge, MIThe pilot’s loss of situational awareness during the approach over a corn field, which resulted in collision with corn stalks.Jul 18, 2017 · N9807D · Substantial damageNTSB CEN17LA257Accident · No injuriesLimited investigationFinal reportCessna 182T · Jackson, MIThe pilot's failure to maintain pitch control during the takeoff roll during an attempted takeoff. Contributing to the accident was the pilot's selection of takeoff flaps after he began the takeoff roll.Jul 5, 2017 · CGBFY · Substantial damageNTSB GAA17CA347Accident · Minor injuriesData collectionFinal reportAeronca 11AC · Watervliet, MIThe flight instructor's inadequate preflight planning, which resulted in a takeoff over maximum gross weight from a turf runway in high density altitude conditions and the airplane’s inability to attain a climb rate and subsequent collision with trees.Jun 16, 2017 · N9404E · Substantial damageNTSB CEN17LA341Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Ray, MIThe pilot's failure to maintain a proper approach speed, which resulted in in a hard landing and a runway excursion. Contributing to the accident was the pilot's decision to fly the airplane without an instructor onboard.May 27, 2017 · N5584U · Substantial damageNTSB CEN17CA218Accident · Minor injuriesData collectionFinal reportCessna 177 · Plainwell, MIThe pilot's improper approach to landing and his failure to perform a go-around, which resulted in a runway overrun.May 26, 2017 · N30462 · Substantial damageNTSB CEN17LA184Accident · No injuriesLimited investigationFinal reportMooney M20E · Dowling, MIInnacurate airspeed indications due to contamination of the pitot-static system with insect remains, which resulted in a high approach and landing speed and subsequent runway overrun.May 15, 2017 · N9265M · Substantial damageNTSB GAA17CA271Accident · No injuriesData collectionFinal reportCessna A185 · Big Rapids, MIThe pilot’s failure to obtain updated weather information while practicing takeoffs and landings and his subsequent failure to maintain directional control during the landing roll in gusting crosswind conditions.May 7, 2017 · N873SL · Substantial damageNTSB CEN17LA178Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Manistee, MIThe failure of the airplane owner and maintenance personnel to follow the propeller manufacturer's recommend overhaul schedule, which resulted in a fatigue fracture of the propeller blade actuating pin and a loss of thrust in flight.Apr 23, 2017 · N2056R · Substantial damageNTSB CEN17LA150Accident · No injuriesLimited investigationFinal reportPiper PA 28R-201 · Pontiac, MIMaintenance personnel’s improper securing of an unused instrument lamp socket during recent maintenance, which resulted in an electrical short of the landing gear controls and stopped the landing gear while it was transitioning to the down position and led to…Apr 9, 2017 · N36458 · Substantial damageNTSB GAA17CA247Accident · No injuriesData collectionFinal reportGrumman American Avn. AA · Flushing, MIThe pilot’s unstabilized approach and subsequent failure to attain the proper touchdown point, which resulted in a runway overrun.Mar 28, 2017 · N9613L · Substantial damageNTSB CEN17LA135Accident · 1 fatalLimited investigationFinal reportLuscombe 8F · Vicksburg, MIThe pilot's inadvertent contact with the propeller while hand propping the engine, which resulted in a fatal injury.Mar 20, 2017 · N2007B · No damageNTSB DCA17FA076Accident · Minor injuriesClass 1 · FieldFinal reportMcdonnell Douglas MD80 · Ypsilanti, MIthe jammed condition of the airplane's right elevator, which resulted from exposure to localized, dynamic wind while the airplane was parked and rendered the airplane unable to rotate during takeoff. Contributing to the accident were (1) the effect of a large…Mar 8, 2017 · N786TW · Substantial damageNTSB GAA17CA142Accident · No injuriesData collectionFinal reportCessna T182 · Three Rivers, MIThe pilot’s failure to maintain sufficient airspeed during the landing flare, which resulted in a hard landing and a nose-over.Feb 19, 2017 · N11344 · Substantial damageNTSB CEN17LA078Accident · Serious injuriesLimited investigationFinal reportTextron 525C · Howell, MIThe pilot's attempted landing on the ice-covered runway, which resulted in a runway excursion and impact with terrain. Contributing to the accident was airport personnel's lack of training regarding issuance of NOTAMsJan 16, 2017 · N525PZ · Substantial damage