NTSB investigations: Continental O-470 series, 1982
15 cases on aircraft whose registry engine model is Continental O-470 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 | 15 |
|---|---|
| 1983 | 15 |
| 1984 | 11 |
| 1985 | 14 |
| 1986 | 4 |
| 1987 | 7 |
| 1988 | 13 |
| 1989 | 11 |
| 1990 | 14 |
| 1991 | 11 |
| 1992 | 8 |
| 1993 | 3 |
| 1994 | 11 |
| 1995 | 6 |
| 1996 | 12 |
| 1997 | 4 |
| 1998 | 9 |
| 1999 | 8 |
| 2000 | 2 |
| 2001 | 8 |
| 2002 | 5 |
| 2003 | 7 |
| 2004 | 5 |
| 2005 | 10 |
| 2006 | 6 |
| 2007 | 14 |
Where
Latest 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\") = 1982
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17026')
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 year(c."eventDate") = 1982
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17026')
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 MKC83LA013Accident · No injuriesLimited investigationFinal reportCessna 182D · Bucklin, KSDuring takeoff, the engine lost power from fuel exhaustion and the pilot made a forced landing in a plowed field. While landing, the wheels dug into the soil and the aircraft nosed over. The pilot stated that he regularily flew another aircraft with a larger…NTSB MIA83LA002Accident · No injuriesLimited investigationFinal reportCessna 182 · Cocoa, FLDuring takeoff, the engine lost power as the aircraft was climbing through about 300 ft AGL. The pilot s-turned and landed on a clear area beside the runway to keep from going into a river. Subsequently, the nose gear collapsed and the aircraft flipped over.…NTSB FTW83FPM01Accident · Serious injuriesFinal reportCessna 180 · Foyil, OKThe pilot reported that he had 20 gal of fuel on board when he took off. He climbed to 10,000 ft for a parachute jump, then returned to the airport with an estimated 10 gal of fuel. During a downwind landing, he elected to go around. He said the engine lost…NTSB FTW82DA395Accident · Minor injuriesFinal reportCessna 182B · Albuquerque, NMThe pilot undershot the runway following an engine failure on final approach. The pilot had been flying 4.7 hours on a cross-country flight when engine quit. The aircraft was out of fuel. The optimum endurance is 4.6 hours. The pilot had figured on 7 gallon…NTSB ATL82DA210Accident · Minor injuriesFinal reportCessna 182 · Mobile, ALThe pilot experienced a power loss during takeoff and made an emergency landing in a soft soybean field. The aircraft nosed over after landing. Water was found in the fuel in the left tank and carburetor. The pilot had also found water inthe left tank during…NTSB NYC82DA136Accident · No injuriesFinal reportCessna 182Q · Sidman, PAAt approximately 10 miles out of johnstown, PA while descending through 5000 ft, the pilot realized he was running out of fuel. At about 4000 ft the pilot spotted a field and an approach to landing was initiated. During the landing roll the front wheel…NTSB ANC82DA052Accident · Minor injuriesFinal reportCessna 182 · Kenai, AKWhile on a flight from mckinley park to Kenai, AK, the pilot flew around the east side of anchorage, so a passenger could take pictures. About half way through the flight, the pilot became concerned about his fuel supply but believed he could reach his…NTSB MKC82DA100Accident · No injuriesFinal reportCessna 182B · Milford, IAThe pilot reported that he was low on fuel and was flying over the airstrip before landing to drop a banner that he was towing. Shortly after the banner was released, the aircraft encountered turbulence causing the aircraft to go into a steep bank. At about…NTSB MIA82DA131Accident · No injuriesFinal reportCessna 182K · Arecibo, PRThe pilot stated that he had 8 gallons of fuel on board before takeoff. At 0700, he departed on a flight from san juan to aguadilla, PR with an intermediate stop at Arecibo, PR for refueling. At about 0725, the aircraft ran out of fuel, about 3 miles from…NTSB CHI82DA187Accident · No injuriesFinal reportCessna 182 · Cedarville, OHThe pilot stated that the engine failed while enroute and an emergency landing was made in a corn field. He also reported that the loss of power was due to carburetor icing. The aircraft was substantially damaged and there were no injuries.NTSB DEN82DA052Accident · Minor injuriesFinal reportCessna 180K · Montrose, CODuring flight over mountainous terrain, the pilot encountered "horizontal snow squalls." He reported that he flew through the snow squall for about 25 miles while maintaining ground contact. He approached a cloud layer, but was able to fly over it at 16,500…NTSB ATL82DA069Accident · Minor injuriesFinal reportCessna 182P · Huntington, WVAccording to the pilot the engine failed after liftoff at about the 3500 foot point down the runway at approximately 300 feet AGL. The runway has 1000 feet of overrun and the aircraft came to rest near the runup area for runway 12. The aircraft had not been…NTSB SEA82DA035Accident · No injuriesFinal reportCessna 182P · Creswell, ORDuring preflight the pilot found water in the fuel system. After fuel drainings and sample checks were completed the pilot started the engine and initiated taxi for takeoff. During taxi and engine runup the engine stopped several times. After repeated fuel…NTSB LAX82FUJ29Accident · Minor injuriesFinal reportCessna 182C · Eloy, AZThe aircraft crashed near the end of a runway on a dark night. The pilot stated to the police that he had run out of fuel. The police found weapons, drugs, and liquor in the pilot's possession. An estimated 3 gallons of fuel was found in each tank. According…NTSB DEN82FTE15Accident · No injuriesFinal reportCessna 182A · Steamboat Sprin, COAfter the pilot entered the traffic pattern for landing, he extended his downwind leg to accomodate the departure of another aircraft. The pilot reported that he pushed the throttle forward as he turned base, but the engine failed to respond. During a forced…