NTSB investigations: Continental C90 series
17 cases on aircraft whose registry engine model is Continental C90 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
| 1983 | 1 |
|---|---|
| 1984 | 2 |
| 1986 | 1 |
| 1987 | 2 |
| 1990 | 1 |
| 1992 | 3 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2002 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17009')
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17009')
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 NYC02LA181Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Belmar, NJThe improper use of an fuel additive which resulted in a power loss. A factor was the lack of suitable terrain.NTSB LAX02LA263Accident · No injuriesLimited investigationFinal reportPravecek Lawrence Varieze · Rio Linda, CAthe loss of engine power caused by fuel exhaustion due to a fuel tank leak. Also causal was the inadequate maintenance performed on the repair of the fuel tank by unknown maintenance personnel.NTSB MIA00LA039Accident · Minor injuriesLimited investigationFinal reportPitts S1C · Creedmore, NCThe pilot's failure to select the reserve position of the fuel tank resulting in loss of engine power due to fuel starvation and a nose over during a forced landing.NTSB ATL97LA062Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Clearwater, FLThe pilot's failure to select the fuller tank for takeoff that resulted in fuel starvation to the engine, and the subsequent total loss of engine power.NTSB FTW96LA367Accident · Minor injuriesLimited investigationFinal reportJackson Sonerai I · Santa Fe, NMthe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel. The lack of suitable terrain for the forced landing was a related factor.NTSB MIA96LA007Accident · No injuriesLimited investigationFinal reportForney ERCOUPE-2 · Cartersville, GAThe pilot-in-command's decision to continue flight with the inoperative fuel transfer pump which resulted in loss of engine power due to fuel starvation. The inoperative fuel transfer pump and the unsuitable terrain encountered during the forced landing were…NTSB FTW94LA249Accident · No injuriesLimited investigationFinal reportCessna 140 · Archer City, TXFuel contamination induced power loss. Factors were the improper refueling techniques used by the pilot and the lack of suitable terrain onto which a forced landing could be executed.NTSB ANC93LA001Accident · No injuriesLimited investigationFinal reportChampion 7EC · Eureka, AKThe pilot-in command's inadequate preflight inspection which resulted in a power loss due to ice in the fuel system.NTSB CHI92LA273Accident · Minor injuriesLimited investigationFinal reportAlon 415-A2 · Sabetha, KSThe pilot's failure to use carburetor heat.NTSB FTW92LA174Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Paris, TXFuel exhaustion power loss. Factors were a loose fuel cap, inadequate preflight by the pilot and the lack of suitable terrain.NTSB CHI90LA259Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Lebanon, ILthe loss of engine power for undetermined reasons while executing a go-around with insufficient runway remaining for a forced landing. A factor in the accident was the structures at the end of the runway that the pilot was attempting to avoid. This report was…NTSB MIA88LA062Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Ocoee, FLThe plt rprtd that before takeoff, he made a thorough preflt, which included a check of the fuel sys for contaminates & water, but no discrepancies were noted. Shortly after takeoff, at an alt of aprx 100 ft, the eng sputtered & lost pwr. The plt stated he…NTSB CHI87LA138Accident · No injuriesLimited investigationFinal reportAeronca 11CC · Inver Grove Hts, MNAfter a loss of power, aircraft stalled. Although power was regained, aircraft crashed approx. 10 feet east of a grass strip adjacent to the seaplane base. Inspection revealed no mechanical malfunction or engine problem.NTSB DEN86LA108Accident · Minor injuriesLimited investigationFinal reportLuscombe T-8F · Watkins, COWhile practicing ground reference maneuvers at 500 ft AGL a total loss of engine power was experienced. The pilot rated passenger in the rear seat performed the emergency landing while the PIC attempted to restart the engine. The landing was made on open…NTSB CHI84LA377Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Olney, ILThe a/c was flown in an airshow by the owner. After he landed the acft was shut down and refueled. The refueling and the preflight were done rapidly to allow the owners son, a student plt, to leave the airport ahead of the crowd. About 3 minutes after takeoff…NTSB MIA84LA245Accident · Serious injuriesLimited investigationFinal reportChampion 7FC · Fort Drum, FLThe acft collided with a power line and the ground after a loss of power during takeoff. The plt was not certificated. The passenger said that the plt attributed the power loss to water in the fuel. The acft was being operated on automobile fuel. Attempts to…NTSB CHI83LA095Accident · No injuriesLimited investigationFinal reportCessna 140 · Richview, ILThe acft collised with a ditch and nosed over during a forced landing after the engine stopped in cruise flt. The pilot said he checked the carburetor heat on the ground but did not use it in the air. After the landing the engine was inspected and no…