NTSB investigations: Continental IO-360 series
29 cases on aircraft whose registry engine model is Continental IO-360 series, where the first occurrence was “Loss of control - in flight”. 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 | 1 |
| 1986 | 1 |
| 1987 | 3 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 3 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 4 |
| 2005 | 2 |
| 2006 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17025', '17045')
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\" = 250))
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 ('17025', '17045')
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" = 250))
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 LAX06FA087Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Lancaster, CAThe student pilot's failure to maintain an adequate airspeed while maneuvering, and, the flight instructor's inadequate supervision of the flight. A factor in the accident was the strong tailwind encountered as the airplane turned from an upwind to a downwind…NTSB MIA06CA021Accident · No injuriesData collectionFinal reportCessna 172R · Kissimmee, FLThe pilot's improper flare and remedial action during landing resulting in an in-flight loss of control and subsequent collision with terrain. A related factor was the crosswind.NTSB IAD05LA055Accident · Serious injuriesLimited investigationFinal reportCessna 337G · Oakland, MDThe pilot's delay in aborting the landing, which resulted in an inadvertent stall/mush into the trees. A factor in the accident was the tailwind.NTSB LAX05FA035Accident · 3 fatalField investigationFinal reportCessna 337B · Drake, AZthe pilot's failure to maintain airspeed above stall speed while maneuvering at low altitude, which resulted in an accelerated stall and spin. A factor in the accident was the pilot's performance of maneuvering flight at an altitude insufficient to allow for…NTSB MIA04FA135Accident · 4 fatalField investigationFinal reportCessna 336 · Magee, MSThe student pilot/ airplane owner's lack of training in night operations, which resulted in spatial disorientation, a loss of control, an uncontrolled descent, and an impact with trees.NTSB LAX04FA241Accident · 1 fatalField investigationFinal reportCessna 337 · Carson City, NVthe pilot's failure to maintain an adequate airspeed while maneuvering during a go-around that led to an inadvertent stall spin.NTSB ATL04FA096Accident · 4 fatalField investigationFinal reportCirrus Design SR20 · Greenwood, SCThe pilot's failure to maintain airspeed during initial climb that resulted in an inadvertent stall and the subsequent collision with trees. A factor was the inadequate preflight planning/preparation when he failed to lower the wing flaps.NTSB DEN03LA022Accident · No injuriesLimited investigationFinal reportMaule M-4-210 · Creede, COthe pilot's inadequate compensation for wind. Contributing factors are the crosswind and the pilot's lack of experience.NTSB LAX01LA256Accident · Serious injuriesLimited investigationFinal reportCessna R172K · Mammoth Lakes, CAThe pilot's inadequate in-flight planning and his failure to maintain sufficient altitude above the terrain. Factors were the high terrain and the blind canyon.NTSB NYC00LA196Accident · No injuriesLimited investigationFinal reportCessna 337C · Chesapeake, VAThe pilot's failure to follow the published go-around procedure. Factors were the pilot's improper evaluation of the wind conditions, and a tailwind.NTSB LAX00FA230Accident · 2 fatalField investigationFinal reportMaule M4-210C · Willows, CAFailure of the pilot to maintain an adequate airspeed margin while maneuvering in steep turns at low altitude in gusty and strong tailwind conditions, which lead to a wind shear encounter and a stall/spin. A contributing factor in the accident was the pilot's…NTSB FTW97LA353Accident · 1 fatalLimited investigationFinal reportAerotek Pitts S-2A · San Marcos, TXThe pilot's loss of control while performing aerobatics resulting in an inadvertent stall/spin. A factor was the lack of altitude available for recovery.NTSB FTW96LA340Accident · No injuriesLimited investigationFinal reportMaule M-4-210C · Hudson, COthe pilot's delay in initiating a go-around and failure to attain sufficient airspeed to clear obstructions at the departure end of the runway, which resulted in an inadvertent stall and collision with the ground. Factors relating to the accident were: the…NTSB LAX95LA336Accident · No injuriesLimited investigationFinal reportSjostrand Wheeler Express · Mariposa, CAthe pilot's premature rotation and liftoff, which resulted in an inadvertent stall and subsequent hard touchdown.NTSB CHI95LA177Accident · Minor injuriesLimited investigationFinal reportCessna R172E · Plato Center, ILthe pilot's excessive pull-up during a downwind banner pick-up resulting in a stall. A factor related to the accident was the tailwind.NTSB BFO95FA006Accident · 2 fatalField investigationFinal reportCessna T337G · Hyannis, MALoss of aircraft control for an undetermined reason. Darkness and the weather conditions were related factors.NTSB NYC94FA176Accident · No injuriesField investigationFinal reportWDL 1B · Farmingdale, NYInadequate design of the airship, which allowed the center ballonet to overfill and to collapse the trunking to the fore and aft ballonets, rendering the airship uncontrollable. Factors related to the accident were: inadequate maintenance by the…NTSB BFO92LA060Accident · Minor injuriesLimited investigationFinal reportCessna 172XP · Milton, DEThe pilot's failure to attain adequate airspeed for climb.NTSB FTW92DQA01Accident · 1 fatalFinal reportAir Trans. White Lightning · Aztec, NMThe inadvertent stall and the pilot's lack of experience in the accident aircraft.NTSB MIA92FA070Accident · 3 fatalField investigationFinal reportCessna 337 · Moore Haven, FLThe pilot-in-command's in flight loss of control due to spatial disorientation. Contributing to the accident was the pilot-in-command's lack of total experience in night flight, and the lack of natural horizon or surface reference while flying over a sparsely…NTSB SEA91FA071Accident · 1 fatalField investigationFinal reportCessna 337 · Boise, IDThe pilot's failure to remove the aircraft control locks prior to attempting flight. Factors include an inadequate preflight.NTSB SEA90FA146Accident · 3 fatalField investigationFinal reportWheeler Technology FT-210 · Linch, WYFailure of the pilot to maintain control of the aircraft and/or correct the stall/spin.NTSB NYC90LA091Accident · No injuriesLimited investigationFinal reportCessna O337F · Brant, NYThe pilot's premature rotation and failure to obtain airspeed.NTSB LAX88LA008Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Fullerton, CADuring a pleasure flt, just after take-off, the acft was observed to climb out at an extremely high rate. The acft leveled off momentarily, and the left wing dropped. The acft began to descend and collided with the runway and two parked acft.NTSB MIA87LA100Accident · No injuriesLimited investigationFinal reportCessna 337E · New Smyrna Bch, FLThe plt stated that on short final the auto-plt activated resulting in an uncontrolled 50-60 degree nose low left bank. The acft then veered from the apch path off the arpt property where it then collided with a vehicle & tree before coming to rest.…NTSB ANC87LA046Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKThe plt lost control of the acft after the tail was raised during takeoff. The acft groundlooped and collided with a snow bank which damaged the rt wing, landing gear and elevator.NTSB LAX86LA078Accident · 1 fatalLimited investigationFinal reportCessna R172K · Kamuela, HIThe acft collided with terrain while maneuvering to aviod clouds during a local scenic flt. The plt stated that turbulence caused loss of control and the acft was blown into trees. The winds were from 050 degs at 37 KTS with gusts to 45 KTS. SIGMET oscar five…NTSB DEN85LA022Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Longmont, COThe pilot stated that he encountered a strong gust of wind from the right and lost directional control. The acft struck the ground with the left wing tip and nose and flipped over.NTSB LAX83LA077Accident · No injuriesLimited investigationFinal reportCessna R172K · San Martin, CAThe acft made a hard landing short of the runway while practicing an approach with a simulated engine failure. On turning final, the instructor decided the acft was too low to make the runway. She estimated they would be several hundred feet short. She took…