NTSB investigations: Cessna 172L
16 cases on aircraft the registry lists as Cessna 172L, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 4 |
| 1989 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2005 | 2 |
Where
Open the mapLatest 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072432')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072432')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 NYC06LA028Accident · No injuriesLimited investigationFinal reportCessna 172L · Lehighton, PAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during takeoff due to fuel contamination, and a subsequent forced landing to a field.NTSB IAD05LA029Accident · No injuriesLimited investigationFinal reportCessna 172L · Poughkeepsie, NYThe pilot's inadequate preflight, which resulted in a loss of engine power due to fuel contamination.NTSB NYC01LA036Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Winchester, VAThe pilot's failure to obtain a pre-departure or en route weather briefing, which led to fuel exhaustion, after his destination and alternate airports were covered by fog. A factor was the fog.NTSB NYC99LA149Accident · No injuriesLimited investigationFinal reportCessna 172L · Millinocket, METhe total loss of engine power for undetermined reasons.NTSB SEA98LA191Accident · No injuriesLimited investigationFinal reportCessna 172L · Puyallup, WAThe pilot-in-command's failure to refuel en-route resulting in fuel exhaustion. Contributing factors were a vehicle (in the landing path) and dark night conditions.NTSB CHI93LA339Accident · No injuriesLimited investigationFinal reportCessna 172L · Curryville, MOImproper preflight planning and procedures by the pilot-in-command which resulted in fuel exhaustion.NTSB ATL92LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Starr, SCThe pilot's inadequate pre-flight planning.NTSB ATL89LA186Accident · No injuriesLimited investigationFinal reportCessna 172L · N Myrtle Beach, SCWater contamination of the airplane fuel supply, and the pilot's failure to adequately preflight the aircraft. A factor related to the accident was: swampy terrain at the emergency landing site.NTSB ATL89LA039Accident · No injuriesLimited investigationFinal reportCessna 172 · Pikeville, KYThe pilot had flown about 3.7 hours and was about 2 miles from his destination airport when the engine stopped and he was forced to land in a swamp. The pilot had topped off the acft so that it contained 42 gallons of fuel (38 gallons of usable fuel). The…NTSB FTW89LA008Accident · Serious injuriesLimited investigationFinal reportCessna 172 · San Antonio, TXThe airplane had been flown for 2.2 hours since refueling when this pilot started his flight. This pilot flew the airplane for 2.5 hours and the engine quit. During the forced landing, the airplane impacted a power pole and power lines, and then the terrain.…NTSB LAX88LA326Accident · No injuriesLimited investigationFinal reportCessna 172L · Banning, CADuring a crosscountry flt, while enroute from lake havasu city, AZ, to Banning, CA, the engine experienced a loss of power. The airplane collided with the terrain after a forced landing. Inspection of the fuel system revealed there was no fuel on board.NTSB NYC88LA199Accident · Minor injuriesLimited investigationFinal reportCessna 172L · No. Kingstown, RIThe failure of the boston center controller to adequately understand the pilot-in-command's request and to assess the gravity of the situation.NTSB BFO86FID01Accident · Minor injuriesFinal reportCessna 172L · Gordonsville, VAOn February 23, 1986, at 1621 EST, a Cessna 172L, N7191Q collided with a tree during an attempted go-around at Gordonsville airport, Gordonsville, VA., while on a pleasure flight. Visual meteorological conditions prevailed at the time and no flight plan was…NTSB CHI85LA282Accident · No injuriesLimited investigationFinal reportCessna 172L · Akron, OHThe acft contacted trees during a forced landing in a cemetery following a loss of pwr while on final apch at Akron fulton arpt. After the accident, 10 gallons of fuel were added to the acft and the eng operated normally when started. An A&P mechanic…NTSB NYC84LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Wilkes-Barre, PADuring flt, the eng lost power from fuel exhaustion & the plt tried to land on a highway. According to witnesses, when he tried to maneuver into the northbound land, while traveling south, the right main gear hit the side of a bank. The wing fuel tanks were…NTSB ANC82FA102Accident · Minor injuriesField investigationFinal reportCessna 172 · Near Kotzebue, AKThe aircraft was landed in the tundra following a power loss returning from a search mission. The lost person was a friend of the pilot of this accident aircraft. Possibly because of this the pilot searched longer than necessary and ran out of fuel on the way…