NTSB investigations: Continental IO-520 series, 1983
9 cases on aircraft whose registry engine model is Continental IO-520 series, where the first occurrence was “Airframe/component/system failure/malfunction”. 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 | 9 |
| 1984 | 7 |
| 1985 | 5 |
| 1986 | 4 |
| 1987 | 7 |
| 1988 | 3 |
| 1989 | 4 |
| 1990 | 3 |
| 1991 | 5 |
| 1992 | 8 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 3 |
| 1997 | 6 |
| 1998 | 8 |
| 1999 | 3 |
| 2000 | 3 |
| 2001 | 9 |
| 2002 | 4 |
| 2003 | 6 |
| 2004 | 4 |
| 2005 | 10 |
| 2006 | 2 |
| 2007 | 4 |
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\") = 1983
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17032')
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\" = 130))
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") = 1983
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17032')
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" = 130))
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 CHI84LA038Accident · No injuriesLimited investigationFinal reportBeech A36 · Columbus, OHOn the return flt to Columbus, OH, the alternator warning light was on. After recycling the switch, the plt shut down all electrical equipment. During arrival at the destination, the plt put the gear handle down, but noted a dim unsafe gear light & a…NTSB MIA84LA010Accident · No injuriesLimited investigationFinal reportCessna 210L · St. Augustine, FLThe acft landed gear up after the landing gear could be extended in flight. The plt stated during the app to St. Augustine attempts to lower the gear were unsuccessful. The gear doors would open and the hydraulic pump was working butthe gear would not extend.…NTSB ATL83LA368Accident · No injuriesLimited investigationFinal reportCessna 310J · Birmingham, ALThe acft landing gear collapsed during landing. An FAA inspector said the gear made grinding noises when extended. During a fly-by the left gear door appeared to be jammed. Reportedly the landing gear transmission assembly failed.NTSB ATL83LA362Accident · No injuriesLimited investigationFinal reportBeech 58 · Chamblee, GAThe acft ran off the departure end of the rwy after an aborted takeoff due to a cabin door opening. The CFI said that more than half the rwy remained when the throttles were retarded and the right door popped open at 91 mph. One attempt was made to close the…NTSB MKC83LA218Accident · No injuriesLimited investigationFinal reportCessna 188B · Catron, MOThe acft went out of control during the takeoff roll from a farm field. The plt states that as the roll began the left wing started to drop and the acft began turning left. The plt tried to correct with right brake but was unable to make a correction. The…NTSB ATL83LA286Accident · No injuriesLimited investigationFinal reportCessna P206B · Suffolk, VAThe parachute of one of the jumpers deployed prematurely. The shroud lines entangled in the right horizontal stabilizer & elevator. As the parachute inflated, the stabilizer was bent downward, & the elevator partially ripped from the trailing edge of the…NTSB ANC83LA099Accident · No injuriesLimited investigationFinal reportCessna 185 · (N) Skwentna, AKThe acft was ground looped intentionally to prevent a collision with people or boats. The pilot said he had no braking action during landing. He believes someone loosened the plugs in the bottom of both brake cylinders and these plugs dropped out in flight.…NTSB ANC83IA060Incident · No injuriesIncident investigationFinal reportCessna C-207A · Eek, AKDuring landing roll the left brake did not respond to the pilots commands. The acft veered off the right side of the runway. The aircraft had maintenance performed on the brakes 2 days before.NTSB MKC83LA058Accident · No injuriesLimited investigationFinal reportBeech D55 · Cape Girardeau, MOThe aircraft was landed gear up on the runway after a business flight. The pilot said he lowered the landing gear handleand observed the green landing gear down light illuminate after receiving clearance to land. The pilot said he did not cross check the nose…