NTSB investigations: Continental 0-200 series, WI
12 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1989 | 2 |
| 1991 | 1 |
| 1993 | 2 |
| 1996 | 1 |
| 1997 | 1 |
| 2003 | 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 ('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\" = 353))
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 ('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" = 353))
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 CHI03LA255Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Lakewood, WIA loss of engine power due to fuel starvation as a result of the pilot's improper use of the fuel system. A related factor was the tree.NTSB CHI97LA088Accident · No injuriesLimited investigationFinal reportCessna 150J · La Valle, WIthe pilot's inadequate pre-flight planning/preparation which led to fuel exhaustion. A factor was the snow covered terrain.NTSB CHI96LA271Accident · No injuriesLimited investigationFinal reportCessna 150 · Wisconsin Rapid, WIfuel exhaustion, due to the pilot's improper planning/decision and inadequate fuel management.NTSB CHI94LA025Accident · No injuriesLimited investigationFinal reportCessna 150M · Franklin, WIFailure of the instructor pilot (CFI) to use carburetor heat during the simulated engine failure, which resulted in carburetor ice and loss of engine power. Factors related to the accident were: carburetor icing conditions and the crop in the emergency…NTSB CHI93LA379Accident · No injuriesLimited investigationFinal reportCessna 150M · Burlington, WIthe improper fuel calculations by the pilot-in-command. Factors were the pilot-in-command's not refueling and uphill terrain.NTSB CHI91DER03Accident · 1 fatalFinal reportVarieze 001 · Superior, WIThe pilot's poor planning and decision making which resulted in a loss of engine power due to fuel exhaustion.NTSB CHI90LA046Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lacrosse, WIThe student pilot's improper pre-flight planning/preparation, which did not include a plan to refuel the aircraft as necessary. The student pilot's lack of total experience contributed to this accident, as did the cfi's inadequate supervision of the student.NTSB CHI89LA044Accident · No injuriesLimited investigationFinal reportCessna 150J · Osceola, WIInadequate preflight by the student pilot, inadequate supervision (to assure a proper preflight) by the instructor pilot (CFI), and water contamination of the fuel. The terrain was considered to be a contributing factor.NTSB CHI88LA037Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Mt. Pleasant, WIThe stu plt climbed to 1600 ft MSL aft tkof. Shortly aft level off, the engine stopped. He attempted an air start without success. During the forced lndg the nose wheel dug in and the acft nosed over in the soft soil. During a post crash interview, the stu…NTSB CHI85LA279Accident · No injuriesLimited investigationFinal reportCessna 150F · Fond Du Lac, WIThe acft nosed over in soft terrain 1/4 mile short of the rwy at fon du lac arpt following a total loss of pwr. The flt departed henderson, KY, at 1510 CDT with 26 gallons of fuel and the pwr loss occurred at 1925 CDT, 4 hrs and 15 minsafter departure. Post…NTSB CHI84LA316Accident · No injuriesLimited investigationFinal reportCessna 150H · Menomonie, WIThe plt was disoriented during a x-country and circled the wrong area looking for an arpt until low fuel demanded a landing. During the approach the engine quit and the acft nosed over in a bean field during landing.NTSB CHI82DA340Accident · No injuriesFinal reportCessna 150H · Genoa City, WIReturning from a cross-country flight the pilot overshot the touchdown point. During the go-around, the engine quit and the aircraft hit a tree. The pilot stated that he did not evaluate his fuel consumption properly.