NTSB investigations: Continental 0-200 series
164 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Loss of engine power”. 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 | 4 |
|---|---|
| 1983 | 3 |
| 1984 | 5 |
| 1985 | 4 |
| 1986 | 4 |
| 1987 | 7 |
| 1988 | 9 |
| 1989 | 3 |
| 1990 | 7 |
| 1991 | 6 |
| 1992 | 6 |
| 1993 | 7 |
| 1994 | 5 |
| 1995 | 3 |
| 1996 | 5 |
| 1997 | 4 |
| 1998 | 8 |
| 1999 | 10 |
| 2000 | 7 |
| 2001 | 12 |
| 2002 | 9 |
| 2003 | 9 |
| 2004 | 6 |
| 2005 | 4 |
| 2006 | 5 |
| 2007 | 12 |
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.engine_model_code IN ('17020')
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\" = 350))
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.engine_model_code IN ('17020')
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" = 350))
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 DFW08LA018Accident · No injuriesLimited investigationFinal reportCessna 150K · Flora, MSLoss of engine power due to fuel contamination. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW08FA004Accident · 2 fatalField investigationFinal reportCessna 150L · Castroville, TXLoss of engine power for undetermined reasons and the pilot receiving instruction's failure to maintain aircraft control resulting in the stall. A factor contributing to the accident was the instructor pilot's delayed remedial action.NTSB NYC07LA232Accident · Minor injuriesLimited investigationFinal reportFrancis SE5A Replica · Hendersonville, NCA total loss of engine power for undetermined reasons.NTSB SEA07LA276Accident · No injuriesLimited investigationFinal reportWerner Vari-Eze · Tooele, UTThe loss of engine power for an undetermined reason. Contributing factors were the lack of suitable terrain for the forced landing and the wind shear conditions encountered during the forced landing attempt.NTSB DEN07LA130Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Cooperstown, NYThe loss of engine power due to carburetor icing. Contributing factors were the lack of suitable terrain for a forced landing and the weather conditions conducive for carburetor icing.NTSB NYC07LA171Accident · 1 fatalLimited investigationFinal reportMidget Mustang M-1 · Covode, PAA loss of engine power for undermined reasons.NTSB CHI07CA217Accident · No injuriesData collectionFinal reportChrapczynski M1 Midget Mustang · Elyria, OHThe pilot's failure to maintain proper glide speed during the forced landing after takeoff, which resulted in an inadvertent stall/mush condition and a hard landing. A contributing factor was the loss of engine power after takeoff for undetermined reasons.NTSB SEA07CA161Accident · No injuriesData collectionFinal reportCessna 150J · Honolulu, HIThe total loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for a forced landing.NTSB CHI07CA169Accident · Minor injuriesData collectionFinal reportCessna 150H · Bellaire, MIA loss of engine power for undetermined reasons. A factor in the accident was the deer fence.NTSB SEA07LA126Accident · 1 fatalLimited investigationFinal reportCessna 150G · Pahrump, NVThe loss of engine power due to fuel contamination followed by the pilot's failure to maintain aircraft control during takeoff. Contributing factors were the pilot's inadequate preflight and an inadequate 100-hour maintenance inspection by other maintenance…NTSB LAX07CA135Accident · Minor injuriesData collectionFinal reportCessna 150L · Watsonville, CAa partial loss of engine power for undertermined reasons during takeoff.NTSB ATL07CA072Accident · Minor injuriesData collectionFinal reportCessna C-150G · Enterprise, ALThe CFI's attempted takeoff with known deficiencies in the engine which resulted in a loss of engine power, a forced landing on muddy terrain, and a nose over.NTSB DFW07CA044Accident · No injuriesData collectionFinal reportCessna 150M · Eastland, TXThe partial loss of engine power for an undetermined reason during cruise flight, which resulted in a forced landing and an overrun. A factor associated with the accident was the pilot's misjudged distance/speed while landing.NTSB MIA07LA028Accident · No injuriesLimited investigationFinal reportCessna 150K · Cape Coral, FLThe pilot's in-flight encounter with carburetor ice and inadequate remedial action which resulted in the engine ceasing to operate and a forced landing and damage to the airplane during the landing.NTSB MIA07LA014Accident · No injuriesLimited investigationFinal reportCessna 150J · DeFuniak Springs, FLThe loss of engine power for undetermined reasons.NTSB ATL06LA086Accident · No injuriesLimited investigationFinal reportCessna 150M · Bishopville, SCThe loss of engine power for undetermined reasons during the approach to land, which resulted in an off-airport emergency landing.NTSB SEA06CA056Accident · No injuriesData collectionFinal reportCessna 150L · Hillsboro, ORThe student pilot's delayed use of carburetor heat in carburetor icing conditions while maneuvering. Soft terrain was a factor.NTSB CHI05LA217Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Mountain View, MOThe loss of engine power for undetermined reasons during climb after takeoff.NTSB ATL05CA095Accident · Minor injuriesData collectionFinal reportDavid S Robbins Christavia MK 1 · Decherd, TNThe pilot's inadequate preflight planning which resulted in fuel exhaustion and subsequent loss of engine power.NTSB SEA05LA107Accident · No injuriesLimited investigationFinal reportCessna 150L · Spokane, WAThe pilot's inadequate in-flight decision by failing to fuel, resulting in fuel exhaustion and the loss of engine power while on approach for landing.NTSB ANC05FA070Accident · 1 fatalField investigationFinal reportTaylorcraft F-19 · Fairbanks, AKThe pilot's failure to maintain a minimum airspeed during a low-altitude turn to return to the airport, and his improper in-flight decision to initiate a steep, low altitude turn, which resulted in an inadvertent stall/spin, and an in-flight collision with…NTSB CHI05LA033Accident · No injuriesLimited investigationFinal reportCessna 150H · Columbia, ILA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight. Factors were the unsuitable field encountered during the forced landing, the muddy field, and the dark night.NTSB CHI04LA292Accident · No injuriesLimited investigationFinal reportCessna 150M · Durand, MIThe elongated exhaust valve leading to the in-flight loss of engine power during initial climb. A factor was the transmission wire the airplane impacted during its emergency landing after takeoff.NTSB FTW04CA122Accident · No injuriesData collectionFinal reportCessna 150E · Goldthwaite, TXThe pilot's inadequate in-flight planning and decision not to refuel, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the dark night conditions.NTSB FTW04LA105Accident · No injuriesLimited investigationFinal reportCessna 150J · Lake Dallas, TXThe pilot's failure to maintain proper airspeed for flight resulting in a stall/spin during the forced landing. A contributing factors was the loss of engine power for undetermined reasons.NTSB FTW04LA121Accident · No injuriesLimited investigationFinal reportCessna 150-G · Livingston, TXA loss of engine power due to the blockage of the fuel system vents, resulting in fuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA04LA042Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Longview, WAFuel exhaustion while maneuvering, as a result of the pilot's inadequate in-flight decision/planning, leading to his failure to refuel the airplane prior to running out of fuel. A ditch was a factor.NTSB ATL04LA009Accident · No injuriesLimited investigationFinal reportCessna 150G · Jeykll Island, GAThe pilot's preflight planning and the mismanagement of the fuel supply that resulted in fuel exhaustion.NTSB FTW04CA002Accident · No injuriesData collectionFinal reportPrice Cuby Acro Trainer · Canutillo, TXThe pilot's failure to refuel the airplane, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the pilot's inadequate in-flight planning and decision making.NTSB CHI03LA281Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Fennimore, WIThe loss of engine power in cruise flight due to carburetor icing. A factor was the unsuitable terrain the pilot encountered during his forced landing.NTSB LAX03CA261Accident · No injuriesData collectionFinal reportCessna 150C · Tucson, AZthe pilot's inadequate inflight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.NTSB NYC03LA134Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Mount Holly, NJA loss of engine power for undetermined reasons.NTSB FTW03LA157Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Temple, TXThe total loss of engine power for an undetermined reason. Contributing factors were the night conditions and the lack of suitable terrain for the forced landing.NTSB ANC03LA033Accident · Serious injuriesLimited investigationFinal reportHughes Stol King · Seldovia, AKThe loss of engine power during initial climb for an undetermined reason, which resulted in a hard landing.NTSB FTW03LA109Accident · No injuriesLimited investigationFinal reportCessna 150G · Hope, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL03LA048Accident · No injuriesLimited investigationFinal reportCessna 150F · Rome, GAThe maintenance personnel failure to secure the throttle linkage during the installation of the carburetor that resulted in the loss of engine power.NTSB FTW02LA248Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Deming, NMThe loss of engine power due to carburetor ice as a result of the pilot's failure to apply carburetor heat. A contributing factor was the weather conducive to carburetor icing conditions.NTSB FTW02LA226Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Manvel, TXThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA02LA133Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Pe Ell, WAThe fatigue failure of the number two engine cylinder for undetermined reasons during cruise flight. Factors include high vegetation in the area where the pilot found it necessary to make a forced landing.NTSB CHI02LA190Accident · No injuriesLimited investigationFinal reportCessna 150F · Ft. Wayne, INThe corroded throttle cable resulting in a loss of engine power. Factors were the inadequate annual inspection, the unsuitable terrain encountered during the forced landing, the ditch, and the fence.NTSB MIA02LA124Accident · No injuriesLimited investigationFinal reportMckean Varieze · Covington, TNThe pilot's improper planned approach following loss of engine power due to fuel starvation resulting in damage to the airplane during an off-airport landing. Contributing to the accident was the pilot's lack of familiarity with the accident airplane.NTSB CHI02LA138Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Kenosha, WIThe student pilot's failure to use carburetor heat, and the flight instructor's inadequate supervision of the flight.NTSB FTW02LA153Accident · No injuriesLimited investigationFinal reportCessna 150M · Godley, TXthe loss of engine power for undetermined reasons. A contributing factor was the pilot's failure to maintain clearance with the transmission wire during the precautionary landing.NTSB NYC02LA078Accident · No injuriesLimited investigationFinal reportCessna 150M · Salisbury Ctr, NYThe pilot's delayed decision to ask for help which led to a power loss due to fuel starvation.NTSB SEA02LA028Accident · No injuriesLimited investigationFinal reportCessna 150M · Clinton, WAFuel exhaustion while in cruise flight resulting in a loss of engine power and the pilot's failure to refuel the aircraft. The pilot's inadequate preflight planning/preparation and a fence post were factors.NTSB CHI01LA328Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Lebanon, INThe unsuitable terrain for landing encountered by the pilot. Factors were the carburetor icing conditions, the carburetor ice, and the bean crop.NTSB IAD01LA099Accident · No injuriesLimited investigationFinal reportCessna 150J · Hyannis, MAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination.NTSB LAX01LA287Accident · No injuriesLimited investigationFinal reportCessna 150M · Murrietta, CAThe failure of the muffler assembly causing a fuel line to overheat, resulting in vapor lock, and a subsequent engine failure followed by an emergency landing in rough terrain.NTSB LAX01LA273Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Fullerton, CAloss of engine power due to fuel contamination.NTSB CHI01LA196Accident · No injuriesLimited investigationFinal reportCessna 150L · Randolph, KSThe unsuitable terrain encountered by the pilot during the forced landing. Factors to the accident were the loss of engine power for undetermined reasons and the rough/uneven terrain condition.