NTSB investigations: Continental IO-360 series
19 cases on aircraft whose registry engine model is Continental IO-360 series, where the first occurrence was “Hard landing”. 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 | 2 |
|---|---|
| 1984 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1993 | 1 |
| 1995 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 2 |
| 2002 | 2 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 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\" = 200))
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" = 200))
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 DFW08CA021Accident · No injuriesData collectionFinal reportCessna 172 · Stillwater, OKThe student pilot's improper recovery from a bounced landing.NTSB DFW06LA060Accident · No injuriesLimited investigationFinal reportCessna 175 · Lindsay, OKThe hard landing was the result of the pilot's failure to maintain adequate airspeed while misjudging the altitude above the runway. Contributing factors were the inadequate quality of the manufacturer's engine-support bracket and the prevailing night…NTSB NYC05CA132Accident · No injuriesData collectionFinal reportCessna R172E · Patuxent River, MDThe pilot's improper recovery from a bounced landing, resulting in a hard landing.NTSB MIA05CA092Accident · No injuriesData collectionFinal reportCessna 337 B · Ocala, FLThe pilot's improper landing flare during an aborted takeoff, which resulted in a hard landing and damage to the airplane.NTSB SEA02LA179Accident · No injuriesLimited investigationFinal reportCessna R172K · Salmon, IDFailure to maintain airspeed while on approach which resulted in an aerodynamic stall and hard landing.NTSB DEN02LA087Accident · No injuriesLimited investigationFinal reportCessna R172K · Monticello, UTthe student pilot's failure to maintain aircraft control during landing flare, which resulted in a hard landing. Contributing factors include the porpoise and subsequent bounced landing and the student pilot's lack of total experience.NTSB ATL01LA096Accident · No injuriesLimited investigationFinal reportCessna R172K · Valdosta, GAThe flight instructor's improper flare of the airplane, which resulted in a hard landing. Factors were the dual student's failure to relinquish control of the airplane and the dual student's interference on the flight controls.NTSB ATL01LA086Accident · No injuriesLimited investigationFinal reportCessna R172-K · Culebras Island, PRPilots improper flare which resulted in a hard landing.NTSB IAD00LA007Accident · No injuriesLimited investigationFinal reportCessna 172XP · Phillipi, WVThe pilot's improper flare that resulted in a hard landing.NTSB CHI99LA002Accident · No injuriesLimited investigationFinal reportCessna C-336 · Sheboygan, WIThe pilot's improper flare and improper recovery from a bounced landing.NTSB CHI96LA042Accident · No injuriesLimited investigationFinal reportCessna T337G · Pontiac, MIthe pilot's improper level-off and improper recovery from a bounced landing.NTSB ATL95LA082Accident · No injuriesLimited investigationFinal reportCessna 337G · Savannah, GAThe pilot's improper flare and his improper use of the flight controls during landing which resulted in collapse of the nose gear.NTSB CHI93LA258Accident · No injuriesLimited investigationFinal reportMaule M4 · Tomahawk, WIthe pilot's improper recovery from a bounced landing.NTSB SEA89LA142Accident · No injuriesLimited investigationFinal reportCessna 172E · Yerington, NVThe pilot's failure to maintain adequate airspeed during a landing go-around in high density altitude conditions.NTSB CHI88LA121Accident · No injuriesLimited investigationFinal reportCessna R172K · Aurora, ILThe pilot said that on final apch, 'a rapid descent took place.' The aircraft touched down on the rwy and bounced. The pilot said he added pwr and lowered the nose, but the nose gear and propeller hit the rwy. The acft bounced again and sustained substantial…NTSB DEN84LA254Accident · No injuriesLimited investigationFinal reportCessna R172K · Los Alamos, NMThe pilot stated that he attempted a landing on rwy 27. The wind was reported to be from 090 degrees at 8 KTS. The plt stated that he touched down on the rwy and the acft skipped to the left. He applied power to go-around but determined that the airspeed was…NTSB NYC84FHD02Accident · 1 fatalFinal reportCessna 337 · Coatsville, PAAfter touchdown about 2,000 ft down the 4,600 x 100 ft rwy the acft bounced back into the air. Witnesses observed the acft rt wing drop causing it to veer to the rt toward a line of parked acft. 900 ft from initial touchdown the acft impacted rt wing first in…NTSB FTW82DA326Accident · No injuriesFinal reportCessna 337D · Gladewater, TXThe pilot made a night landing, nose high and dragged the rear propeller. In attempting a go-around, he dragged a wing and decided to abort. During the aborted go-around, he ran off the end of the runway and damaged the aircraft on rough, brushy terrain. The…NTSB MIA82DA119Accident · No injuriesFinal reportCessna 172K · Geneva, FLThe pilot stated that while on short final a gust of wind raised the right wing of the aircraft. Upon making a correction some airspeed was lost and the nose was lowered. During landing the nose gear collapsed and the aircraft turned over.