Skip to content

NTSB investigations: Cessna 172P, NJ

28 cases on aircraft the registry lists as Cessna 172P. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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."eventStateOrRegion" = 'NJ' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072436')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"eventStateOrRegion\" = 'NJ' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072436'))
  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.

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."eventStateOrRegion" = 'NJ' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072436'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB ERA23LA333Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Port Norris, NJThe pilot’s improper fuel management, which resulted in fuel starvation and a total loss of engine power.Aug 11, 2023 · N5453K · Substantial damage NTSB ATL07LA106Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Sussex, NJA loss of engine power for undetermined reasons.Jul 22, 2007 · N63483 · Substantial damage NTSB NYC05CA143Accident · No injuriesData collectionFinal reportCessna 172P · Caldwell, NJThe student pilot's failure to maintain directional control while landing. A factor in this accident was the crosswind condition.Sep 19, 2005 · N64763 · Substantial damage NTSB NYC05LA125Accident · No injuriesLimited investigationFinal reportCessna 172P · Caldwell, NJThe pilot's improper flare, which resulted in a hard landing. A factor was a partial loss of engine power, as reported by the pilot, for undetermined reasons.Jul 28, 2005 · N98730 · Substantial damage NTSB NYC05CA082Accident · No injuriesData collectionFinal reportCessna 172P · Caldwell, NJThe student pilot's improper flare and recovery from a bounced landing.May 11, 2005 · N64815 · Substantial damage NTSB IAD05CA037Accident · No injuriesData collectionFinal reportCessna 172P · Cross Keys, NJThe pilots failure to maintain directional control. Factors contributing to the accident were the pilots lack of experience, and the snow bank.Feb 7, 2005 · N54812 · Substantial damage NTSB NYC03LA065Accident · No injuriesLimited investigationFinal reportCessna 172P · Linden, NJThe pilot's inadequate compensation for the crosswind and his failure to maintain directional control during landing. Factors in the accident were the crosswind and the snowbank.Mar 10, 2003 · N30EF · Substantial damage NTSB IAD02LA038Accident · No injuriesLimited investigationFinal reportCessna 172P · Ocean City, NJThe pilot's inadequate compensation for wind and his failure to maintain directional control.Mar 24, 2002 · N9847L · Substantial damage NTSB NYC00LA256Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Cross Keys, NJThe operator's inadequate 100-hour inspection of the airplane, and the pilot's continued operation with known deficiencies in equipment.Sep 8, 2000 · N9594L · Substantial damage NTSB IAD00LA068Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Princeton, NJthe student pilot's failure to maintain control of the airplane during the aborted landing.Jul 29, 2000 · N65827 · Substantial damage NTSB NYC98LA163Accident · Minor injuriesLimited investigationFinal reportCessna 172P · West Milford, NJThe student pilot's improper recovery from a bounced landing and the instructor's inadequate supervision of the flight.Aug 7, 1998 · N116FR · Substantial damage NTSB NYC97LA136Accident · No injuriesLimited investigationFinal reportCessna 172P · Wildwood, NJThe pilot's inadequate use of carburetor heat, which resulted in carburetor icing.Jul 6, 1997 · N97011 · Substantial damage NTSB NYC97LA090Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Morristown, NJThe flight instructor's inadequate supervision which allowed the student to solo at night with less than one hour of night instruction with a known inoperative landing and taxi light. A Factor was the student pilot's spatial disorientation which resulted in…May 13, 1997 · N65983 · Substantial damage NTSB NYC96LA149Accident · No injuriesLimited investigationFinal reportCessna 172P · Fairfield, NJthe pilot's improper aborted takeoff by extending full flaps which resulted in a porpoise. Subsequently, the airplane veered off the runway and the nose gear collapsed.Jul 13, 1996 · N98730 · Substantial damage NTSB NYC95LA172Accident · No injuriesLimited investigationFinal reportCessna 172P · Teterboro, NJthe student pilot's improper flare which resulted in the airplane porpoising and the subsequent buckling of the firewall.Jul 24, 1995 · N51081 · Substantial damage NTSB NYC93FA158Accident · 1 fatalField investigationFinal reportCessna 172N · Lincoln Park, NJThe failure of both pilots to maintain adequate visual lookout while in the airport traffic pattern, which resulted in an in-flight collision.Aug 15, 1993 · N5226E · 2 aircraft · Destroyed NTSB NYC93LA101Accident · No injuriesLimited investigationFinal reportCessna 172P · Lincoln Park, NJThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control of the airplane, which resulted in a ground swerve and a collision with trees.Jun 6, 1993 · N97055 · Substantial damage NTSB BFO93LA079Accident · No injuriesLimited investigationFinal reportCessna 172P · Pittstown, NJThe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, which resulted in a ground swerve. The gusty wind and proximity of the parked airplane were related factors.May 10, 1993 · N54833 · Substantial damage NTSB NYC93LA055Accident · No injuriesLimited investigationFinal reportCessna 172P · Teterboro, NJThe failure of the pilot to maintain directional control during landing which resulted in the airplane departing the runway and nosing over. Factors related to the accident were the crosswind and the soft terrain encountered by the airplane.Jan 23, 1993 · N52491 · Substantial damage NTSB NYC93LA051Accident · No injuriesLimited investigationFinal reportCessna 172 · Andover, NJThe pilot's failure to abort the landing which resulted in a overrun of the runway. Contributing was the pilot's misjudgement of distance and an improper touchdown point.Dec 22, 1992 · N54102 · Substantial damage NTSB BFO92FA069Accident · 2 fatalField investigationFinal reportCessna 172P · Princeton, NJThe pilot's failure to maintain clearance over an obstacle. Contributing factors were a tailwind, dark night, and premature raising of the flaps.May 19, 1992 · N55110 · Destroyed NTSB BFO92LA066Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Caldwell, NJThe pilot's improper IFR operation. Contributing was the pilot's lack of recent instrument flight time.May 16, 1992 · N54860 · Destroyed NTSB NYC87LA174Accident · Minor injuriesLimited investigationFinal reportCessna 172 · West Milford, NJThe Cessna 172 is reported to have lost power after getting airborne while making a short field takeoff from a 1838 ft long runway. The student pilot told the operator he landed the aircraft on the remaining runway and ran off the departure end of the runway.…Jun 16, 1987 · N9638L · Substantial damage NTSB NYC85LA084Accident · No injuriesLimited investigationFinal reportCessna 172P · Princeton, NJThe acft experienced nose gear damage following a loss of control during touchdown. The plt stated the acft touched down on the main gear and bounced as the nose gear was being lowered. After the acft porpoised several times the plt was able to regain control…Mar 16, 1985 · N62541 · Substantial damage NTSB NYC84LA296Accident · No injuriesLimited investigationFinal reportCessna 172P · Manville, NJAcft swerved on rwy before rotation and climbed aprx 10 feet before settling back on the rwy. Plt aborted the takeoff but was unable to stop before end of rwy.Aug 21, 1984 · N65665 · Substantial damage NTSB NYC84LA106Accident · No injuriesLimited investigationFinal reportCessna C172 · Fairfield, NJThe acft hit a snowdrift during landing roll and veered left into a snowbank. The acft nosed down, striking the right wing tip and propellers.Mar 10, 1984 · N64493 · Substantial damage NTSB NYC83LA205Accident · No injuriesLimited investigationFinal reportCessna 172 · Atlantic City, NJThe acft landed long and fast, ran off the end of the rwy & collided with a fence.Aug 8, 1983 · N66098 · Substantial damage NTSB NYC82DA074Accident · No injuriesFinal reportCessna 172 · Morristown, NJThe student pilot proceeded to the Morristown municipal airport to practice touch and go landings. He stated that during his first touch and go, the right wing picked up. He initiated a go-around to correct the problem. However, during the go-around, a wing…Apr 19, 1982 · N54576 · Substantial damage