NTSB investigations: Continental 0-300 series, NY
99 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 | 5 |
|---|---|
| 1965 | 8 |
| 1966 | 6 |
| 1967 | 8 |
| 1968 | 8 |
| 1969 | 4 |
| 1970 | 7 |
| 1971 | 2 |
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 4 |
| 1975 | 1 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 1 |
| 1979 | 5 |
| 1980 | 3 |
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 2 |
| 1989 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 3 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 2 |
| 2011 | 2 |
| 2012 | 1 |
| 2015 | 2 |
| 2016 | 2 |
| 2018 | 1 |
| 2020 | 1 |
| 2025 | 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.\"eventStateOrRegion\" = 'NY' 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" = 'NY' 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 ERA25LA123Accident · No injuriesClass 4 · LimitedFinal reportCessna 172C · Argyle, NYThe mechanic’s incorrect installation of the oil temperature gauge probe in the oil filter adapter and failure to test run the engine for oil leaks after the installation, which resulted in a total loss of oil and the pilot’s decision to perform a…NTSB ERA25LA121Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Syracuse, NYThe truck driver’s to see and avoid the airplane, which resulted in a collision.NTSB ERA21LA091Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Pleasant Valley, NYA total loss of engine power due to failure of the magnetos, which were not overhauled in accordance with the manufacturer’s time specifications.NTSB GAA18CA267Accident · No injuriesData collectionFinal reportCessna 172 · Fulton, NYThe student pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB GAA17CA018Accident · Minor injuriesData collectionFinal reportCessna 172 · Argyle, NYThe pilot’s failure to maintain a stable descent rate and his improper landing flare, which resulted in a hard landing.NTSB ERA16FA161Accident · 2 fatalField investigationFinal reportCessna 172 · Westmoreland, NYThe pilot's decision to takeoff on the grass runway given the conditions at the time; his excessive aft control input during the takeoff roll, which resulted in the aft fuselage contacting the runway surface; and his failure to attain sufficient airspeed and…NTSB GAA16CA044Accident · No injuriesData collectionFinal reportCessna 172G · Newfane, NYAn evasive maneuver during landing to avoid deer on the runway, which resulted in a runway overrun and collision with trees.NTSB ERA15FA203Accident · 1 fatalField investigationFinal reportCessna 172 · Penn Yan, NYThe student pilot's failure to maintain airplane control during the initial climb. Contributing to the accident was the student's inappropriate configuration of the airplane's wing flaps for the initial climb.NTSB ERA12CA320Accident · Minor injuriesData collectionFinal reportCessna 172F · Cambridge, NYThe pilot’s loss of airplane control during a takeoff in variable crosswind conditions.NTSB ERA11CA331Accident · Serious injuriesData collectionFinal reportCessna 172 · Ghent, NYThe pilot's delayed decision to abort the landing and execute a go-around.NTSB ERA11CA144Accident · No injuriesData collectionFinal reportCessna 172H · Plattsburgh, NYThe student pilot's loss of directional control during the landing flare in gusting wind conditions and the certified flight instructor's delayed remedial action.NTSB NYC08LA199Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Brockport, NYA total loss of engine power due to fuel exhaustion as a result of the flight instructor's inadequate preflight planning.NTSB NYC08CA170Accident · Minor injuriesData collectionFinal reportCessna 172F · White Plains, NYThe pilot's failure to maintain the proper glide path during the approach.NTSB NYC07CA069Accident · No injuriesData collectionFinal reportCessna 172 · Utica, NYThe pilot's failure to maintain directional control of the airplane, during an aborted takeoff, which resulted in a collision with a snowbank.NTSB NYC07CA049Accident · Minor injuriesData collectionFinal reportCessna 172C · Middletown, NYThe pilot misjudging distance/altitude during the turn from base to final, which resulted in an undershoot and subsequent collision with trees. A factor was the haze.NTSB NYC04LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Cooperstown, NYThe pilot's failure to maintain adequate airspeed and her premature rotation which resulted in an inadvertent stall/mush and subsequent impact with the ground.NTSB IAD04FA031Accident · 1 fatalField investigationFinal reportCessna 172C · Edinburgh, NYThe pilot's occluded left main coronary artery, which resulted in a massive heart attack and sudden death in flight.NTSB NYC04CA068Accident · No injuriesData collectionFinal reportCessna 172E · Batavia, NYThe pilot's failure to maintain directional control while landing. Factors were a tailwind and icy runway.NTSB NYC04LA046Accident · No injuriesLimited investigationFinal reportCessna 172E · Islip, NYThe pilot's failure to maintain aircraft control, which resulted in a nose over. A factor in this accident was the gusty wind conditions.NTSB NYC02LA024Accident · No injuriesLimited investigationFinal reportCessna 172D · Argyle, NYThe pilot's failure to maintain aircraft control while maneuvering.NTSB IAD00LA080Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Halfmoon, NYThe pilot's inadequate preflight planning, and his continued flight into, and attempted landing during a thunderstorm. A factor was the thunderstorm.NTSB IAD00LA057Accident · Serious injuriesLimited investigationFinal reportCessna 172G · North Elba, NYthe pilot's inaccurate fuel consumption calculations and exhaustion of his fuel supply.NTSB IAD99LA067Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Honeoye Falls, NYthe pilot's loss of directional control after landing. A factor in the accident were ruts in the turf runway that were hidden from view.NTSB IAD98LA096Accident · No injuriesLimited investigationFinal reportCessna 172G · Williamson, NYDirectional control not maintained by one of the pilot's on board the airplane.NTSB NYC96LA144Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Pleasant Valley, NYfailure of the pilot to maintain obstacle clearance from trees during a precautionary landing. His becoming lost was a related factor.NTSB NYC89LA134Accident · No injuriesLimited investigationFinal reportMaule M-4 · Csttltn-Hdsn, NYThe pilot's selection of unsuitable terrain. A contributing factor was the wet, soft grass.NTSB NYC87LA037Accident · No injuriesLimited investigationFinal reportPiper J3 · Montgomery, NYWhile taxiing in the middle of the taxiway the propeller of N58380 contacted the wing of N7416T. N58380 then rotated and it's wing contacted the wing of N7416T. N7416T was stopped alongside the taxiway when the accident occurred.NTSB NYC86LA062Accident · No injuriesLimited investigationFinal reportCessna 172 · Durhamville, NYThe flight was returning from a 4-LEG 300-mile cross country trip. On flare touchdown, the pilot reported severe vibration. As brakes were applied the vibration increased, and the aircraft became uncontrollable. The aircraft pulled to the right and collided…NTSB NYC86LA047Accident · No injuriesLimited investigationFinal reportCessna 172 · East Moriches, NYThe acft was substantially damaged when it collided with trees during a forced landing following a loss of pwr during a takeoff climb. The plt reported that the pwr loss resulted from carb ice.NTSB NYC83LA199Accident · No injuriesLimited investigationFinal reportCessna 172 · Easton, NYThe plt reported that during landing the brakes locked & the acft then hit two bumps in the rwy & ballooned. The acft then skidded off the end of the rwy, collided with a plowed furrow & flipped inverted.NTSB NYC81FFJ01Accident · No injuriesClosedCessna 172 · Hamburg, NYNTSB NYC80DFA22Accident · Serious injuriesClosedCessna 172 · Saranac Inn, NYNTSB NYC80FFA18Accident · Serious injuriesClosedCessna 172 · Highland Falls, NYNTSB NYC80FA015Accident · 1 fatalClosedCessna 172 · Washingtnville, NYNTSB NYC79DFA36Accident · No injuriesClosedCessna 172 · Shinhopple, NYNTSB NYC79FH214Accident · No injuriesClosedCessna 172H · Mt Kisco, NYNTSB NYC79FHM09Accident · No injuriesClosedCessna 172 · Spring Valley, NYNTSB NYC79FFA09Accident · Serious injuriesClosedCessna 172H · Malone, NYNTSB NYC78DFJ42Accident · No injuriesClosedCessna 172 · Wellsville, NYNTSB NYC77DFA34Accident · No injuriesClosedCessna 172 · Watertown, NYNTSB NYC77DFA20Accident · No injuriesClosedCessna 172 · Ticonderoga, NYNTSB NYC76FHM29Accident · No injuriesClosedCessna 172H · Mahopac, NYNTSB NYC76FFA34Accident · No injuriesClosedCessna 172 · Albany, NYNTSB NYC76DFA12Accident · No injuriesClosedCessna 172 · Otter Lake, NYNTSB NYC75DFJ12Accident · No injuriesClosedMaule M-4 · Windsor, NYNTSB NYC75FHJ27Incident · No injuriesClosedCessna 172 · Ronkonkoma, NYNTSB NYC74DFA24Accident · No injuriesClosedCessna 172 · Ellenville, NYNTSB NYC74FHM16Accident · No injuriesClosedCessna 172H · Newburgh, NYNTSB NYC74AN028Accident · No injuriesClosedCessna 172 · Ronkonkoma, NYNTSB NYC73FHJ21Accident · Minor injuriesClosedCessna 172 · Edgewater Park, NY