NTSB investigations: Cessna 172N

134 cases on aircraft the registry lists as Cessna 172N, where the sequence of events included Collision with terr/obj (non-CFIT). Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Cases, newest first

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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072434')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND 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 CEN18FA024Accident · 4 fatalField investigationFinal reportCessna 172N · Hatch, NMThe pilot's failure to maintain airspeed during the initial climb after takeoff, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall/spin.Nov 4, 2017 · N251CH · Substantial damageNTSB GAA18CA024Accident · No injuriesData collectionFinal reportCessna 172 · Old Bridge, NJThe student pilot’s failure to maintain directional control during the landing roll.Oct 17, 2017 · N6384D · Substantial damageNTSB ERA17LA293Accident · No injuriesLimited investigationFinal reportCessna 172 · Guntersville, ALThe pilot's failure to maintain directional control on takeoff.Aug 21, 2017 · N73929 · Substantial damageNTSB WPR17FA171Accident · 2 fatalField investigationFinal reportCessna 172N · Big Bear, CAThe pilot's exceedance of the airplane's critical angle of attack during takeoff in high density altitude conditions, which resulted in an aerodynamic stall, loss of control, and subsequent impact with terrain.Jul 29, 2017 · N5381J · Substantial damageNTSB ERA17CA250Accident · No injuriesData collectionFinal reportCessna 172 · Factoryville, PAThe pilot's failure to attain the proper touchdown point, which resulted in a runway overrun.Jul 20, 2017 · N4876F · Substantial damageNTSB GAA17CA276Accident · No injuriesData collectionFinal reportCessna 172 · Monument Valley, UTThe pilot’s improper landing flare, which resulted in a bounced landing.May 12, 2017 · N9390E · Substantial damageNTSB GAA17CA219Accident · Minor injuriesData collectionFinal reportCessna 172 · Millbrook, NYThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during landing with a crosswind, which resulted in an aerodynamic stall and an off-runway landing.Apr 2, 2017 · N734SN · Substantial damageNTSB WPR17FA023Accident · 1 fatalField investigationFinal reportCessna 172N · Moss Beach, CAThe pilot's loss of airplane control following an encounter with low level wind shear and turbulence during final approach for landing. Contributing to the loss of control was the pilot's decision to retract the wing flaps on final approach, which resulted in…Nov 18, 2016 · N6610D · Substantial damageNTSB GAA17CA012Accident · No injuriesData collectionFinal reportCessna 172 · Ocean Springs, MSThe pilot's failure to maintain airplane control while landing in windy conditions.Oct 8, 2016 · N3379E · Substantial damageNTSB ERA16FA309Accident · 2 fatalField investigationFinal reportCessna 172 · Hollywood, FLThe pilot's inadequate preflight and in-flight weather planning, which resulted in continued flight into a thunderstorm and a subsequent loss of airplane control.Sep 3, 2016 · N6091E · DestroyedNTSB GAA16CA460Accident · No injuriesData collectionFinal reportCessna 172 · Winchester, VAThe student pilot's incorrect pitch control during the landing flare, which resulted in a porpoise, a loss of directional control, and a runway excursion.Aug 30, 2016 · N2462E · Substantial damageNTSB GAA16CA417Accident · No injuriesData collectionFinal reportCessna 172 · Everett, WAThe pilot's failure to maintain clearance from the building door, which resulted in substantial damage to the left wing.Aug 4, 2016 · N4801D · Substantial damageNTSB ERA16LA231Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Hollywood, FLA partial loss of engine power during the initial climb for undetermined reasons.Jun 26, 2016 · N734UF · Substantial damageNTSB GAA16CA316Accident · No injuriesData collectionFinal reportCessna 172 · Cornelia, GAThe student pilot's unnecessary pedal application and the flight instructor's delayed remedial action resulting in a loss of directional control, runway excursion and ground impact during the aborted landing.Jun 8, 2016 · N444WM · Substantial damageNTSB GAA16CA181Accident · No injuriesData collectionFinal reportCessna 172 · Orangeburg, SCThe pilot's failure to maintain directional control during the takeoff, resulting in a runway excursion and a nose over.Apr 3, 2016 · N2124E · Substantial damageNTSB ERA16FA141Accident · 1 fatalField investigationFinal reportCessna 172N · Charleston, WVThe flight instructor's failure to ensure that her seat was properly secured before initiating the takeoff, which resulted in a subsequent loss of control. Contributing was the lack of an installed secondary seat stop.Mar 26, 2016 · N6238D · Substantial damageNTSB CEN16FA083Accident · 1 fatalField investigationFinal reportCessna 172N · Gilmer, TXThe pilot's inadequate preflight planning and inspection, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's failure to maintain an appropriate traffic pattern altitude and distance from the…Jan 13, 2016 · N737EZ · Substantial damageNTSB CEN16FA073Accident · 1 fatalField investigationFinal reportCessna 172N · Wayne, NEThe noninstrument-rated pilot's improper decision to continue visual flight into instrument meteorological conditions, which resulted in a collision with terrain.Jan 4, 2016 · N5104D · Substantial damageNTSB GAA16CA073Accident · No injuriesData collectionFinal reportCessna 172N · Boca Raton, FLThe pilot's failure to maintain directional control during the landing touchdown resulting in a runway excursion, a collision with an object, and an impact with terrain.Dec 3, 2015 · N5185D · Substantial damageNTSB GAA15CA235Accident · No injuriesData collectionFinal reportCessna 172N · Kalispell, MTThe pilot's loss of directional control, which resulted in a runway excursion, and collision with runway and taxiway lights and terrain.Aug 19, 2015 · N733NH · Substantial damageNTSB GAA15CA156Accident · No injuriesData collectionFinal reportCessna 172N · Vernal, UTThe pilot's failure to maintain directional control during landing in crosswind conditions, which resulted in a runway excursion and an impact with an airport sign.Jun 26, 2015 · N3159E · Substantial damageNTSB WPR15LA086Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Ualapue, HIA partial loss of engine power during cruise flight for reasons that could not be determined because the airplane was not recovered.Jan 17, 2015 · N5660E · Substantial damageNTSB CEN14FA435Accident · 1 fatalField investigationFinal reportCessna 172N · Natchitoches, LAThe partial loss of engine power due to the exhaust valve rocker retaining stud backing out of the cylinder head, which resulted in the exhaust valve being stuck in the closed position. Contributing to the accident was the pilot’s failure to configure the…Aug 17, 2014 · N734YW · Substantial damageNTSB ERA14CA375Accident · Minor injuriesData collectionFinal reportCessna 172N · Valkaria, FLThe pilot's misjudgment of speed and distance on final approach during a precautionary landing, resulting in a touchdown off the departure end of the runway and collision with terrain. A factor in the accident was a partial loss of engine power for reasons…Aug 6, 2014 · N9400E · Substantial damageNTSB CEN14CA353Accident · No injuriesData collectionFinal reportCessna 172N · Edgewood, NMThe pilot's in-flight loss of control resulting from a crosswind gust encountered immediately after takeoff.Jul 10, 2014 · N4842G · Substantial damageNTSB WPR14LA235Accident · No injuriesLimited investigationFinal reportCessna 172N · Page, AZThe pilot’s improper landing flare in gusting wind conditions, his inadequate recovery from the subsequent bounced landing, and his decision to perform a go-around with insufficient airspeed to climb.Jun 8, 2014 · N5589E · Substantial damageNTSB CEN14CA186Accident · No injuriesData collectionFinal reportCessna 172N · Marine City, MIThe pilot's improper recovery from a bounced landing.Mar 21, 2014 · N739RX · Substantial damageNTSB WPR14CA116Accident · No injuriesData collectionFinal reportCessna 172 - N · Glendale, AZThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a runway excursion and subsequent impact with a taxiway sign.Feb 15, 2014 · N738BH · Substantial damageNTSB CEN14CA123Accident · Minor injuriesData collectionFinal reportCessna 172N · Boulder, COThe pilot's failure to maintain airplane control during final approach with known turbulence present.Jan 25, 2014 · N738LQ · Substantial damageNTSB WPR14LA080Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Pacoima, CAThe flight instructor’s inadequate compensation for the gusting crosswind conditions during landing, which resulted in a loss of airplane control.Dec 29, 2013 · N4936D · Substantial damageNTSB ERA14CA081Accident · No injuriesData collectionFinal reportCessna 172N · Farmingdale, NJThe student pilot's improper landing flare, which resulted in a hard landing.Dec 13, 2013 · N2854E · Substantial damageNTSB WPR13LA299Accident · No injuriesLimited investigationFinal reportCessna 172 - N · Trout Lake, WAThe pilot's failure to maintain clearance from trees during takeoff from a soft field and to abort the landing when the airplane reached the runway’s midpoint at a low airspeed.Jun 28, 2013 · N75542 · Substantial damageNTSB WPR13CA225Accident · No injuriesData collectionFinal reportCessna 172N · Newcastle, WYThe student pilot's failure to attain the proper touchdown point, which resulted in an undershoot of the runway.May 10, 2013 · N7610F · Substantial damageNTSB WPR13LA209Accident · No injuriesLimited investigationFinal reportCessna 172N · Henderson, NVThe pilot’s inadequate preflight planning, including operating in excess of the maximum certified gross weight and center of gravity limits at a high density altitude, which resulted in the airplane’s inability to maintain a positive rate of climb after…Apr 28, 2013 · N3483E · Substantial damageNTSB CEN13CA246Accident · No injuriesData collectionFinal reportCessna 172N · New Orleans, LAThe pilot's failure to perform a steep climb before going around following a low pass for a banner tow pickup.Apr 28, 2013 · N737FK · Substantial damageNTSB ERA13FA217Accident · Minor injuriesField investigationFinal reportCessna 172N · Dade City, FLThe in-flight loosening of the No. 3 cylinder exhaust valve rocker arm stud, which resulted in a complete loss of engine power.Apr 27, 2013 · N5944J · Substantial damageNTSB ERA13CA210Accident · No injuriesData collectionFinal reportCessna 172N · Stow, MAThe pilot’s failure to maintain directional control while landing in gusty wind conditions.Apr 20, 2013 · N739CK · Substantial damageNTSB ERA13CA202Accident · Minor injuriesData collectionFinal reportCessna 172N · Summersville, WVThe pilot's failure to maintain directional control of the airplane while landing, which resulted in a runway excursion.Apr 13, 2013 · N6136F · Substantial damageNTSB ERA13CA137Accident · Minor injuriesData collectionFinal reportCessna 172N · Okeechobee, FLThe pilot’s failure to maintain directional control during takeoff.Feb 18, 2013 · N6249D · Substantial damageNTSB CEN13CA074Accident · No injuriesData collectionFinal reportCessna 172N · Poplar Grove, ILThe pilot’s failure to maintain directional control of the airplane while landing.Nov 18, 2012 · N4811G · Substantial damageNTSB ERA13FA059Accident · 3 fatalField investigationFinal reportCessna 172N · Owls Head, METhe vehicle driver's failure to verify that the runway was not occupied by an airplane before crossing the runway, which resulted in the vehicle being struck by a departing airplane, and the pilot's continued takeoff with flight control damage, which…Nov 16, 2012 · N6142F · Substantial damageNTSB ERA13WA205Accident · 4 fatalForeign investigationCessna 172N · Acreúna Municipality, BrazilSep 9, 2012 · N1009F · DestroyedNTSB WPR12CA375Accident · No injuriesData collectionFinal reportCessna 172 · Sand Point, IDA deer strike during the landing flare. Contributing to the accident was the airport’s lack of any deer incursion prevention measures, such as an airport perimeter fence.Aug 28, 2012 · N3082E · Substantial damageNTSB CEN12FA154Accident · 1 fatalField investigationFinal reportCessna 172N · Floresville, TXThe medical incapacitation of the pilot due to a sudden cardiac arrhythmia or acute myocardial infarction.Feb 10, 2012 · N5427J · Substantial damageNTSB WPR12LA093Accident · 1 fatalLimited investigationFinal reportCessna 172N · Fresno, CAThe non-certificated pilot’s failure to maintain clearance from power lines. Contributing to the accident was the pilot’s impairment due to performance-impairing drugs.Feb 6, 2012 · N7582D · Substantial damageNTSB CEN12CA099Accident · No injuriesData collectionFinal reportCessna 172N · Wauseon, OHThe student pilot's loss of directional control during landing.Dec 3, 2011 · N737ET · Substantial damageNTSB ERA12LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Pompano Beach, FLThe separation of the throttle cable from its fitting, which resulted in an inability to control engine power. Contributing to the accident was the inadequate maintenance by the owner.Nov 1, 2011 · N739JN · Substantial damageNTSB CEN12CA030Accident · No injuriesData collectionFinal reportCessna 172N · Covington, LAThe pilot’s failure to maintain adequate airspeed during a banner drop, resulting in an aerodynamic stall.Oct 17, 2011 · N2401E · Substantial damageNTSB CEN11CA674Accident · No injuriesData collectionFinal reportCessna 172N · Wadsworth, OHThe pilot's misjudgment of his speed and distance, which resulted in an overrun.Sep 22, 2011 · N9348E · Substantial damageNTSB CEN11CA580Accident · No injuriesData collectionFinal reportCessna 172N · Winnsboro, LAThe pilot's failure to maintain aircraft control during takeoff with a gusting crosswind.Aug 18, 2011 · N3209E · Substantial damage