NTSB investigations: Continental 0-300 series, 2002
30 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 | 183 |
|---|---|
| 1965 | 197 |
| 1966 | 237 |
| 1967 | 250 |
| 1968 | 163 |
| 1969 | 112 |
| 1970 | 114 |
| 1971 | 113 |
| 1972 | 96 |
| 1973 | 87 |
| 1974 | 53 |
| 1975 | 51 |
| 1976 | 61 |
| 1977 | 68 |
| 1978 | 65 |
| 1979 | 49 |
| 1980 | 37 |
| 1981 | 48 |
| 1982 | 31 |
| 1983 | 31 |
| 1984 | 34 |
| 1985 | 31 |
| 1986 | 38 |
| 1987 | 39 |
| 1988 | 35 |
| 1989 | 27 |
| 1990 | 28 |
| 1991 | 23 |
| 1992 | 29 |
| 1993 | 30 |
| 1994 | 22 |
| 1995 | 32 |
| 1996 | 29 |
| 1997 | 18 |
| 1998 | 31 |
| 1999 | 28 |
| 2000 | 27 |
| 2001 | 28 |
| 2002 | 30 |
| 2003 | 37 |
| 2004 | 28 |
| 2005 | 32 |
| 2006 | 27 |
| 2007 | 28 |
| 2008 | 23 |
| 2009 | 18 |
| 2010 | 22 |
| 2011 | 17 |
| 2012 | 20 |
| 2013 | 21 |
| 2014 | 12 |
| 2015 | 22 |
| 2016 | 17 |
| 2017 | 20 |
| 2018 | 22 |
| 2019 | 23 |
| 2020 | 13 |
| 2021 | 30 |
| 2022 | 17 |
| 2023 | 19 |
| 2024 | 17 |
| 2025 | 25 |
| 2026 | 10 |
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 year(c.\"eventDate\") = 2002
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 year(c."eventDate") = 2002
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 IAD03LA022Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Leeds, MAThe flight instructor's failure to ensure adequate fuel onboard, which resulted in fuel exhaustion and a total loss of engine power.NTSB LAX03LA042Accident · No injuriesLimited investigationFinal reportCessna 170B · Mobile, AZthe pilot's improper compensation for the crosswind conditions at touchdown and failure to maintain proper alignment of the tail wheel equipped airplane during landing, which resulted in a ground loop. The crosswind was a contributory factor.NTSB NYC03LA025Accident · No injuriesLimited investigationFinal reportCessna 172G · Stow, MAThe pilot's failure to maintain adequate altitude/clearance. A factor in this accident was gusty wind conditions.NTSB FTW03LA030Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Fort Stockton, TXThe pilot's decision to conduct VFR flight into IMC and his failure to maintain terrain clearance. Contributing factors were the dark night, clouds, fog, and the lack of suitable terrain.NTSB LAX02LA293Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Weed, CAThe pilot's failure to follow adequate hand propping engine starting procedures.NTSB LAX02LA290Accident · No injuriesLimited investigationFinal reportCessna 172G · Vail, AZThe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion.NTSB SEA02LA169Accident · No injuriesLimited investigationFinal reportCessna 172 · W. Yellowstone, MTThe pilot's compensation for the wind conditions was inadequate during the landing roll. A quartering tailwind was a factor.NTSB ANC02LA105Accident · No injuriesLimited investigationFinal reportCessna 172H · Fairbanks, AKThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane exiting the runway and colliding with objects. Factors contributing to the accident were the rough and uneven runway, and the premature lift-off of the…NTSB ANC02LA096Accident · No injuriesLimited investigationFinal reportCessna 170 · Soldotna, AKThe pilot's inadequate recovery from a bounced landing, and his failure to maintain directional control of the airplane. A factor contributing to the accident was the pilot's excessive braking which resulted in a nose over.NTSB NYC02LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Sangerville, METhe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall.NTSB FTW02LA203Accident · 1 fatalLimited investigationFinal reportCessna 172B · Denton, TXThe pilot's misjudgment of distance and altitude. Contributing factors were the pilot's diverted attention and the runway localizer antenna.NTSB SEA02LA107Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Troutdale, ORA loss of engine power for an undetermined (non-mechanical) reason. Contributing factors were high grass and soft terrain which lead to the collapse of the nose gear during the landing roll.NTSB CHI02LA167Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Butler, MOThe fuel exhaustion, the inadequate fuel consumption calculations by the pilot, and the inadequate in-flight planning/decision by the pilot. The unsuitable terrain encountered during the forced landing is a contributing factor.NTSB DEN02LA053Accident · No injuriesLimited investigationFinal reportCessna 172F · Salt Lake City, UTthe pilot's improper in-flight planning and decisions, which resulted in fuel exhaustion. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB ATL02FA121Accident · 1 fatalField investigationFinal reportCessna 172H · Palmetto, FLThe pilot's failure to maintain airspeed which resulted in a stall while maneuvering after a banner release.NTSB FTW02LA170Accident · No injuriesLimited investigationFinal reportCessna 172E · Navajo Dam, NMthe pilot's failure maintain directional control of the airplane during a touch and go landing which resulted in a collision with trees. A contributing factor was the gusting wind conditions.NTSB SEA02LA090Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Carey, IDThe pilot's failure to maintain clearance from trees during takeoff.NTSB ATL02FA104Accident · 3 fatalField investigationFinal reportCessna 172C · Ball Ground, GAThe flight instructor's failure to maintain adequate obstacle clearance, which resulted in an inflight collision with trees.NTSB LAX02LA168Accident · No injuriesLimited investigationFinal reportCessna 170B · Show Low, AZThe pilot's improper recovery from a bounced landing resulted in a loss of aircraft control. A factor was a sudden wind shift on final approach.NTSB LAX02LA159Accident · No injuriesLimited investigationFinal reportCessna 170B · San Diego, CAThe failure of the dual student to maintain directional control of the airplane and the instructor's delayed the remedial action, which resulted in a ground loop. A factor in the accident was the gusting crosswind conditions.NTSB ATL02LA096Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Livingston, TNThe pilot failure to maintain flying speed, followed by a subsequent stall.NTSB ANC02LA031Accident · No injuriesLimited investigationFinal reportCessna 172 · Fairbanks, AKThe pilots improper starting procedure. Factors associated with the accident are the continued operation of the airplane with a known mechanical deficiency, and failure to use wheel chocks and/or tie-down rope/straps to restrain the airplane during the engine…NTSB CHI02LA125Accident · No injuriesLimited investigationFinal reportCessna 172 · Redfield, SDthe failure of the pilot to maintain directional control while taxing to takeoff in high and gusty wind conditions.NTSB MIA02LA087Accident · No injuriesLimited investigationFinal reportCessna 172H · Ehrhardt, SCthe pilot's failure to attain proper touchdown point while landing on a wet grass runway, resulting in the airplane departing the runway and impacting with trees.NTSB ATL02LA081Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Smithfield, NCThe pilot's inadequate in-flight planning that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB FTW02LA084Accident · No injuriesLimited investigationFinal reportCessna 172A · Albuquerque, NMthe pilot's delay in executing a go-around while conducting a simulated emergency landing, which resulted in an in flight collision with terrain.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 CHI02LA079Accident · No injuriesLimited investigationFinal reportCessna 172H · Hackensack, MNThe pilot's inadequate compensation for the winds conditions which resulted in the failure to maintain directional control of the airplane. Factors associated with the accident were the gusty crosswind conditions and the trees alongside the runway which the…NTSB CHI02LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Manito, ILThe pilot's improper planning and decision and his failure to maintain adequate airspeed, which resulted in a stall and hard landing. The gusting crosswind conditions were a contributing factor.NTSB ATL02LA036Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Bellewood, MSThe pilot misjudged the proper touched down point and collided with the ground short of the runway during an attempted landing.