NTSB investigations: Continental 0-300 series, 1996
29 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\") = 1996
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") = 1996
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 FTW97LA050Accident · No injuriesLimited investigationFinal reportCessna 172H · Hammond, LAthe pilot's inadequate preflight, resulting in the total loss of engine power due to fuel exhaustion.NTSB IAD97LA009Accident · 1 fatalLimited investigationFinal reportCessna 172A · Lebanon, OHimproper aircraft handling by the tow pilot and/or the glider pilots, which allowed the tow plane and glider to get out of position with one another; and failure of the aircrews (in both aircraft) to ensure a timely release of the glider tow rope.NTSB IAD97LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Germantown, KYimproper maintenance with the installation of an improper oil ring on the number four piston, which led to failure of both the ring and pistion, oil starvation, and subsequent loss of engine power.NTSB LAX97LA007Accident · No injuriesLimited investigationFinal reportCessna 172C · Mesa, AZthe pilot's improper use (positioning) of the fuel selector, which resulted in fuel starvation and loss of engine power.NTSB NYC97LA002Accident · No injuriesLimited investigationFinal reportCessna 172H · Chatham, MAthe pilot's improper flare, which resulted in a hard landing. A factor relating to the accident was: the pilot's lack of experience in the make and model of airplane.NTSB CHI96LA350Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Germantown Hill, ILthe pilot's inadequate fuel supply and his misjudging distance and altitude. The trees were a factor.NTSB CHI96FA348Accident · 1 fatalField investigationFinal reportCessna 172F · Saint Clair, MNa loss of power due to the engine's #2 cylinder exhaust valve stuck open, and the pilot's failure to maintain airspeed.NTSB LAX96LA345Accident · No injuriesLimited investigationFinal reportCessna 172F · Ehrenberg, AZThe pilot's attempt to perform a low altitude evasive maneuver with inadequate airspeed resulting in a stall/mush.NTSB ANC96LA153Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKthe pilot's selection of unsuitable terrain for taxiing.NTSB CHI96LA329Accident · No injuriesLimited investigationFinal reportCessna 172 · Wellston, MIThe pilot failed to maintain control of the aircraft. Factors were the rough road, the tree, and the tire.NTSB LAX96LA316Accident · No injuriesLimited investigationFinal reportCessna 172F · Ocotillo, CAthe pilot's failure to maintain proper runway alignment. The sun glare and proximity of rocks were related factors.NTSB FTW96LA362Accident · No injuriesLimited investigationFinal reportCessna 172H · Durango, COthe pilot's improper flaring of the airplane at too high an altitude, resulting in a hard landing.NTSB ANC96LA127Accident · No injuriesLimited investigationFinal reportCessna 170B · Cantwell, AKA failure of the pilot to provide sufficient takeoff distance from the edge of the departure lake and his premature liftoff.NTSB ANC96LA108Accident · No injuriesLimited investigationFinal reportCessna 170B · Northway, AKThe pilot's failure to maintain directional control of the airplane during landing.NTSB SEA96LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Kettle Falls, WAthe pilot's inadequate preflight planning. Factors relating to the accident were: high ambient temperatures; departing from a short, grass runway; and tall trees off the departure end of the airstrip.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 FTW96LA281Accident · No injuriesLimited investigationFinal reportCessna 172H · Pierce, COa loss of engine power for undetermined reasons. A factor was the unsuitable terrain.NTSB MIA96LA164Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Jonesville, SCthe pilot's inadequate visual lookout and failure to maintain altitude and/or clearance from the obstruction (power line) during low altitude flight. The lack of natural lighting at dusk was a related factor.NTSB ANC96LA090Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing and the failure to maintain directional control of the airplane. A factor in the accident was an airstrip that was rough and uneven.NTSB FTW96LA207Accident · Minor injuriesLimited investigationFinal reportBowers Midget Mustang M-1 · Mesquite, TXThe pilot's failure to maintain aircraft control following the separation of the propeller spinner installed by the pilot. A factor was the pilot's failure to obtain the required FAA inspection for the installation.NTSB LAX96LA209Accident · No injuriesLimited investigationFinal reportCessna 172 · Marana, AZthe pilot's improper flare and improper recovery from a bounced landing.NTSB ANC96LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Fairbanks, AKThe student pilot's premature flare and the flight instructor's failure to perform remedial action prior to the hard landing.NTSB IAD96FA057Accident · 3 fatalField investigationFinal reportCessna 172 · Barkhamsted, CTthe CFI pilot/passenger's poor judgment which led to spatial disorientation and subsequent loss of control of the airplane. Factors involved in this accident were the night marginal visual flight conditions and continuing flight with a known nonfunctioning…NTSB LAX96LA143Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Upland, CAfuel system contamination and the pilot's intentional operation of a known unairworthy aircraft.NTSB CHI96LA106Accident · No injuriesLimited investigationFinal reportCessna 172E · Tofte, MNthe pilot's failure to perform adequate preflight planning which resulted in landing at a closed airport. The snow covered runway was a factor.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 ATL96LA060Accident · No injuriesLimited investigationFinal reportCessna 172D · Macon, GAThe pilot's improper planning/decision, which resulted in fuel exhaustion. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB MIA96FA089Accident · 2 fatalField investigationFinal reportCessna 172D · Hawthorne, FLthe pilot's failure to maintain the proper glidepath during an instrument approach.NTSB BFO96LA041Accident · No injuriesLimited investigationFinal reportCessna 172D · Rineyville, KYthe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.