NTSB investigations: Continental 0-300 series, WI
62 cases on aircraft whose registry engine model is Continental 0-300 series. 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
| 1964 | 3 |
|---|---|
| 1965 | 2 |
| 1966 | 5 |
| 1967 | 6 |
| 1968 | 2 |
| 1969 | 4 |
| 1970 | 2 |
| 1971 | 2 |
| 1972 | 5 |
| 1973 | 2 |
| 1977 | 3 |
| 1978 | 6 |
| 1979 | 1 |
| 1980 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 2 |
| 1992 | 1 |
| 1994 | 2 |
| 1996 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2010 | 1 |
| 2013 | 1 |
| 2016 | 1 |
| 2024 | 1 |
| 2026 | 1 |
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.\"eventStateOrRegion\" = 'WI' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17022'))
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" = 'WI' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17022'))
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 CEN26LA273Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172F · Antigo, WINTSB CEN24LA266Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172G · West Bend, WIThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN17LA090Accident · No injuriesLimited investigationFinal reportCessna 172B · Prairie Du Sac, WIThe pilot's decision to taxi the airplane from the roadway and his subsequent failure to maintain clearance from signs and a fence after a successful emergency landing following a total loss of engine power.NTSB CEN13LA216Accident · No injuriesLimited investigationFinal reportCessna 172 · Wonewoc, WIThe restricted vented fuel cap and obstructed fuel vent lines, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN10CA578Accident · No injuriesData collectionFinal reportCessna 172B · Oconomowoc, WIThe pilot's selection of unsuitable terrain for landing the float-equipped airplane on a turf runway.NTSB CHI02LA081Accident · No injuriesLimited investigationFinal reportCessna 172F · Lynxville, WIThe pilots delayed use of carburetor heat during carburetor icing conditions, and the unsuitable terrain encountered for the forced landing. The carburetor icing conditions, the powerline, the brush, and the nose gear collapse were contributing factors.NTSB CHI01LA004Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Sparta, WIthe pilot's inaccurate fuel consumption calculations, improper fuel management, inadequate in-flight planning/decision, flight to destination alternate not performed, and the discontinued planned approach to the initially selected runway. Contributing factors…NTSB CHI96LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Camp Lake, WIFailure of the pilot to maintain clearance from trees that were located beside the runway.NTSB CHI95LA023Accident · No injuriesLimited investigationFinal reportCessna 172F · Cross Plains, WIthe pilot's failure to use carburetor heat. Factors were carburetor icing conditions and rough/uneven terrain.NTSB CHI94LA239Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Marinette, WIThe pilot's inadequate compensation for the wind conditions encountered. Factors associated with this accident were the pilot's inadequate remedial action and the gusty wind conditions.NTSB CHI92FA119Accident · 1 fatalField investigationFinal reportCessna 172H · Browntown, WISpatial disorientation and the pilot's failure to maintain control of the airplane. Factors associated with this accident were the snow conditions, an inadequate weather evaluation by both the student and instructor, over confidence in personal ability,…NTSB CHI88LA212Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Crandon, WIDuring cruise flight in deteriorating meteorological conditions, the pilot experienced a total loss of engine power. The pilot performed emergency procedures, was unable to restart the engine, and executed a forced landing in a clover field. The aircraft…NTSB CHI88LA070Accident · No injuriesLimited investigationFinal reportCessna 172A · Crivitz, WIThe aircraft did not accelerate as anticipated by the pilot, who was attempting to takeoff from a wet sod strip. The pilot elected to abort the takeoff, however was unable to stop on the remaining runway, exited the departure end, struck a snow bank and nosed…NTSB CHI87LA169Accident · No injuriesLimited investigationFinal reportCessna 172 · Madison, WIThe instructor (CFI) & pvt plt (student) were on a renter's check-out flt to familiarize the student with a Cessna 172. While practicing landings, tower psnl provided a windshear alert. Drg an apch to land, the acft went into a high sink rate over the apch…NTSB CHI86LA095Accident · No injuriesLimited investigationFinal reportCessna 172C · Waupun, WIDrg arrival for a x-wind landing, the plt made a high apch & used full flaps to steepen his dscnt over trees near the apch end of the rwy. He stated that the touchdown was normal, but before he could raise the flaps, the x-wind pushed the plane to the left.…NTSB CHI85LA341Accident · No injuriesLimited investigationFinal reportCessna 172H · Whitewater, WIAccording to the plt he planned to use max performance takeoff procedures out of the owner's manual for the takeoff. After brake release the acft began to roll down the sod rwy. Acceleration continued, but according to the plt, his airspeed increase seemed…NTSB CHI85LA264Accident · No injuriesLimited investigationFinal reportCessna 172H · Coleman, WIThe pilot departed on a short x-country flt. Stated fuel aboard was 8 gls. Pilot diverted from drct flt and ran out of fuel after one hour airborne. Ld in farm field. Struck a post with resultant sub damage to airframe.NTSB CHI84LA213Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Port Washington, WIThe plt stated that after takeoff from a sod field covered with tall grass, the acft drifted to the right of the rwy. While bringing the acft back to the center of the rwy, the acft stalled. The nose gear hit the ground & collapsed, the left wing hit a fence…NTSB CHI80DEP35Accident · No injuriesClosedCessna 172D · Delavan, WINTSB CHI79FEP22Accident · No injuriesClosedCessna 172 · Sturgeon Bay, WINTSB CHI79DEP14Accident · No injuriesClosedCessna 172 · Sturgeon Bay, WINTSB CHI79DEP05Accident · Minor injuriesClosedCessna 172 · Shawano, WINTSB CHI78FEP69Accident · No injuriesClosedCessna 172F · Sauk Prairie, WINTSB CHI78FEP50Accident · No injuriesClosedCessna 172 · Tony, WINTSB CHI78FEP30Accident · No injuriesClosedCessna 172 · Middleton, WINTSB CHI78FEP21Accident · No injuriesClosedCessna 172H · Fond Du Lac, WINTSB CHI77FEP60Accident · No injuriesClosedCessna 170 · Mosinee, WINTSB CHI77FEP47Accident · Serious injuriesClosedCessna 172 · Lake Geneva, WINTSB CHI77DER02Accident · No injuriesClosedCessna 172F · Glenwood City, WINTSB CHI74FEP10Accident · Serious injuriesClosedCessna 172 · Cadott, WINTSB CHI73DEP57Accident · No injuriesClosedCessna 172G · Wilmot, WINTSB CHI73FEP33Accident · No injuriesClosedCessna 172C · New Holstein, WINTSB CHI73FEP28Accident · Minor injuriesClosedCessna 172D · Franklin, WINTSB CHI72DEP52Accident · No injuriesClosedCessna 172 · Sturtevant, WINTSB CHI72FEP32Accident · Minor injuriesClosedCessna 172G · Thorp, WINTSB CHI72DEP34Accident · No injuriesClosedCessna 172G · Burlington, WINTSB CHI71AC062Accident · No injuriesClosedCessna 172K · Sussex, WINTSB CHI71DDJ35Accident · Minor injuriesClosedCessna 172G · Hales Corners, WINTSB CHI71DDJ28Accident · No injuriesClosedCessna 172 · Reedsburg, WINTSB CHI71FDM02Accident · No injuriesClosedCessna 172G · Mondovi, WINTSB CHI70D0070Accident · Minor injuriesClosedCessna 172 · Waukesha, WINTSB CHI70F0273Accident · Minor injuriesClosedCessna 172D · Dodgeville, WINTSB CHI69D0587Accident · No injuriesClosedCessna 172C · Middleton, WINTSB CHI69D0540Accident · Minor injuriesClosedCessna 172 · Wautoma, WINTSB CHI69D0531Accident · No injuriesClosedCessna 172 · Ridgeland, WINTSB CHI68D0579Accident · No injuriesClosedCessna 172 · Brussels, WINTSB CHI68D0383Accident · No injuriesClosedCessna 172 · Milwaukee, WINTSB CHI68D0375Accident · No injuriesClosedCessna 172 · Ft.Atkinson, WINTSB CHI68A0048Accident · No injuriesClosedCessna 172 · Palmyra, WINTSB CHI67F0603Accident · Minor injuriesClosedCessna 172F · Burlington, WI