NTSB investigations, 2022, MI

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, 2022, 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\") = 2022
    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 CEN23LA067Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172F · Auburn Hills, MIThe catastrophic engine failure due to lack of oil lubrication, which resulted from the pilot’s failure to follow the airplane and engine manufacturers’ guidance for cold weather operation.Dec 21, 2022 · N8768U · Substantial damageNTSB CEN23LA036Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Manchester, MIA partial loss of engine power as a result of carburetor ice.Nov 13, 2022 · N222UM · Substantial damageNTSB CEN23LA286Accident · No injuriesClass 4 · LimitedFinal reportHonda HA-420 · Holland, MIThe pilot’s failure to maintain directional control during the landing roll with gusty wind which exceeded the maximum crosswind of the airplane.Oct 12, 2022 · N704JT · Substantial damageNTSB CEN22LA442Accident · No injuriesClass 3 · LimitedInvestigation openPiper PA-18 · Battle Creek, MISep 27, 2022 · N7207NTSB CEN22LA410Accident · Minor injuriesClass 4 · LimitedFinal reportWaco Classic 2T-1A-2 · Coldwater, MIThe pilot receiving instruction’s improper flare during landing and the flight instructor’s inadequate remedial action, which resulted in the airplane exceeding its critical angle-of-attach and experiencing an aerodynamic stall.Sep 2, 2022 · N21GL · Substantial damageNTSB CEN22LA403Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Houghton Lake, MIA loss of engine power during cruise flight for undetermined reasons.Aug 31, 2022 · N2270L · Substantial damageNTSB DCA22LA191Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 717-200 · Detroit, MIAn encounter with moderate turbulence during descent.Aug 29, 2022 · N946AT · No damageNTSB CEN22LA398Accident · No injuriesClass 3 · LimitedFinal reportCessna 172I · Olivet, MIThe pilot’s failure to attain/maintain a proper glidepath that resulted in a hard landing and impact with the runway.Aug 28, 2022 · N46202 · Substantial damageNTSB CEN22LA385Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Sparta, MIThe pilot’s delayed decision to reject the takeoff, resulting in a runway excursion and impact with a fence.Aug 10, 2022 · N55338 · Substantial damageNTSB ERA22FA351Accident · 2 fatalClass 3 · FieldFinal reportSmith Aerostar 600 · South Haven Charter Township, MIA loss of power to the left engine due to contamination of the fuel system. Contributing to the accident was the pilots’ failure to properly configure the airplane for flight with one engine inoperative.Aug 2, 2022 · N9784Q · DestroyedNTSB CEN22LA358Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Mecosta, MIThe pilot’s decision to depart on inadequate runway surface conditions that resulted in a loss of control after attempting to abort the takeoff, a runway excursion, and a nose over.Jul 30, 2022 · N2902N · Substantial damageNTSB CEN22LA336Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Ray, MIThe pilot’s early rotation on takeoff, which resulted in insufficient airspeed and an inability to gain sufficient altitude to clear the trees.Jul 24, 2022 · N60ED · Substantial damageNTSB ERA22FA314Accident · 2 fatalClass 3 · FieldFinal reportCessna 210C · Shelby, MIThe non-instrument rated pilot’s decision to commence the flight in instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control. Contributing to the accident was the pilot’s self-induced pressure to…Jul 15, 2022 · N3659Y · DestroyedNTSB CEN22LA249Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Eaton Rapids, MIThe pilot’s failure to maintain airspeed in the climb with a quartering tailwind which resulted in an aerodynamic stall and subsequent impact with trees.Jun 14, 2022 · N3553M · Substantial damageNTSB CEN22LA251Accident · No injuriesClass 3 · LimitedFinal reportTrojan TA16 · Ray, MIA lack of lubrication and inadequate cooling, which resulted in internal damage to the engine and a subsequent total loss of engine power.Jun 2, 2022 · N36YR · Substantial damageNTSB CEN22LA194Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · Traverse City, MIThe failure of maintenance personnel to properly torque a fuel line “B” nut, which resulted in a total loss of engine power.May 10, 2022 · N184NW · Substantial damageNTSB CEN22LA126Accident · No injuriesClass 4 · LimitedFinal reportEmbraer Executive EMB-500 · Detroit, MIThe pilot’s decision to land on the contaminated runway with previous reports of unfavorable braking action.Feb 18, 2022 · N68NH · Substantial damage