NTSB investigations: Continental O-470 series
161 cases on aircraft whose registry engine model is Continental O-470 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, newest first
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 ('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\" = 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 ('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" = 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 CHI99LA338Accident · No injuriesLimited investigationFinal reportCessna 182R · Fargo, NDthe pilot misjudged the landing flare which resulted in the airplane porpoising during the landing.NTSB CHI99LA251Accident · No injuriesLimited investigationFinal reportCessna 180 · Frankfort, MIthe inadequate flare and the go-around not performed by the pilot.NTSB CHI99LA244Accident · No injuriesLimited investigationFinal reportCessna 182N · Green Bay, WIThe pilot's delayed flare and his improper recovery from a bounced landing.NTSB SEA99LA094Accident · No injuriesLimited investigationFinal reportCessna 182 · Redmond, ORThe pilot's improper flare.NTSB LAX99LA224Accident · No injuriesLimited investigationFinal reportCessna 180K · Santa Monica, CAThe pilot's misjudged landing flare which resulted in a hard landing and the subsequent porpoising of the airplane; and his failure to maintain directional control that resulted in a ground loop and substantial damage to the airplane.NTSB MIA99LA035Accident · No injuriesLimited investigationFinal reportCessna 182C · St. Petersburg, FLthe pilot misjudged the flare, resulting in a hard land and subsequent damage to the airplane.NTSB ATL99LA018Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hickory, NCThe pilot's failure to properly recover from a bounced landing.NTSB CHI98LA327Accident · No injuriesLimited investigationFinal reportCessna 310B · Breezy Point, MNthe pilot's improper flare of the airplane, and his not maintaining control of the airplane.NTSB IAD98LA093Accident · No injuriesLimited investigationFinal reportCessna 182 · Edgartown, MAwas the pilot's improper flare prior to touchdown.NTSB CHI98LA261Accident · No injuriesLimited investigationFinal reportCessna 182A · Springbrook, WIThe pilot's improper attitude and excessive sink rate during landing. The terrain condition was a contributing factor in the accident.NTSB ANC98LA051Accident · No injuriesLimited investigationFinal reportCessna 182A · Palmer, AKThe pilot's failure to abort the landing. A factor associated with the accident is the presence of a variable wind condition.NTSB IAD98LA069Accident · No injuriesLimited investigationFinal reportCessna 182L · Marlborough, MAThe pilot's improper flare. A related factor was the crosswind.NTSB LAX98LA060Accident · No injuriesLimited investigationFinal reportCessna 180H · Santa Ynez, CAThe pilot's improper flare. Related factors were the crosswind conditions.NTSB LAX98LA023Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hamburg, CAthe pilot's improper flare, which resulted in a hard landing and overload failure of the nose gear. High terrain (obstruction) near the approach end of the runway was a related factor.NTSB LAX97LA249Accident · No injuriesLimited investigationFinal reportCessna 182G · Fresno, CAthe pilot's improper flare, which resulted in a hard landing and damage to the airplane.NTSB IAD97LA100Accident · No injuriesLimited investigationFinal reportCessna 182H · Pedrictown, NJThe pilot's improper flare.NTSB NYC97LA113Accident · No injuriesLimited investigationFinal reportCessna 182N · Frederick, MDThe private pilot's improper flare, and the certificated flight instructor's delayed decision to add power, which resulted in the subsequent hard landing.NTSB FTW97LA195Accident · No injuriesLimited investigationFinal reportCessna 182K · Little Rock, ARthe pilot's improper flare and improper recovery from a bounced landing.NTSB SEA97LA054Accident · No injuriesLimited investigationFinal reportCessna 182M · Vancouver, WAThe pilot-in-command's touchdown with an excessive rate of descent. Factors included gusty crossiwnds.NTSB SEA96LA174Accident · No injuriesLimited investigationFinal reportCessna 182B · Metaline Falls, WAthe pilot's improper flare and improper recovery from a bounced landing. The inadvertent porpoise was a related factor.NTSB IAD96LA101Accident · No injuriesLimited investigationFinal reportCessna 182P · White Marsh, MDThe pilot's improper flare which resulted in a hard landing. A related factor was the pilot's improperly planned approach.NTSB MIA96LA151Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Crestview, FLFailure of the pilot-in-command to maintain the proper descent rate on landing resulting in separation of the nose landing gear after touchdown. Contributing to the accident was the pilot's lack of experience in the type of operation.NTSB FTW96LA217Accident · No injuriesLimited investigationFinal reportCessna 182J · Jacksonville, TXthe pilot's inadequate compensation for the wind conditions. A factor was the gusting wind conditions.NTSB LAX96LA136Accident · No injuriesLimited investigationFinal reportCessna 182Q · Avalon, CAthe pilot's improper flare and improper recovery from a bounced landing. Factors relating to the accident were: a visual illusion due to rising terrain at the approach end of the runway, and the pilot's misjudgment of distance and speed during the approach to…NTSB CHI96LA089Accident · No injuriesLimited investigationFinal reportCessna 210 · Shelbyville, ILthe pilot's misjudged flare and improper recovery from a bounced landing. Factors relating to the accident were: the pilot's improper use of procedure by wearing unapproved correcting lenses, and his resultant decreased depth perception.NTSB LAX96LA021Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Auburn, CAthe pilot's failure to maintain directional control following a hard landing. His physical impairment was a factor.NTSB CHI95LA168Accident · No injuriesLimited investigationFinal reportCessna 180D · Eveleth, MNthe pilot's improper setting of the flaps to the 30 degree position and an excessive descent rate during the landing.NTSB FTW95LA178Accident · No injuriesLimited investigationFinal reportCessna 182D · Overbrook, OKThe pilot's failure to maintain flying speed, resulting in an inadvertent stall. A factor was the crosswinds.NTSB MIA95LA091Accident · No injuriesLimited investigationFinal reportCessna 182Q · Fort Lauderdale, FLThe pilot-in-command's improper landing touchdown and improper recovery from a bounced landing.NTSB BFO95LA034Accident · No injuriesLimited investigationFinal reportCessna 182K · Gretna, VAThe pilot's improper flare which resulted in a hard landing.NTSB FTW94LA314Accident · No injuriesLimited investigationFinal reportCessna 182N · Cortez, COThe pilot's improper recovery from a bounced landing.NTSB ANC94LA139Accident · No injuriesLimited investigationFinal reportCessna 182B · Ketchikan, AKThe failure of the pilot to maintain directional control of the airplane during a hard landing. The pilot's improper recovery from a bounced landing and a downdraft were factors in the accident.NTSB SEA94LA144Accident · No injuriesLimited investigationFinal reportCessna 182P · Salt Lake City, UTAn improper flare by the pilot, who was landing the aircraft, at the time it was damaged.NTSB FTW94LA207Accident · No injuriesLimited investigationFinal reportCessna 182L · Mineola, TXThe pilot's delayed landing flare and his improper bounced landing technique.NTSB LAX94LA067Accident · No injuriesLimited investigationFinal reportCessna 182Q · Grand Canyon, AZthe pilot's use of an excessive approach airspeed and an improper bounced landing recovery technique.NTSB SEA94LA017Accident · No injuriesLimited investigationFinal reportCessna 182R · Tooele, UTAirspeed was not maintained.NTSB BFO93LA192Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Batavia, OHThe pilot's improper flare.NTSB SEA93LA201Accident · No injuriesLimited investigationFinal reportCessna 182H · Salt Lake City, UTThe pilot's improper flare. Inadequate recovery from a bounced landing was factor.NTSB CHI93LA317Accident · No injuriesLimited investigationFinal reportCessna 182M · Ironwood, MIThe pilot's improper flare for landing.NTSB MIA93LA023Accident · No injuriesLimited investigationFinal reportCessna 182 · Macon, GAThe pilot in command's failure to stabilize his approach to landing, resulting in the aircraft making a hard landing halfway down the runway.NTSB LAX92LA394Accident · No injuriesLimited investigationFinal reportCessna 180 · Avalon, CAThe pilot's improper landing flare which resulted in a hard landing and a collapse of the left main landing gear.NTSB SEA92LA177Accident · No injuriesLimited investigationFinal reportCessna 182Q · Afton, WYThe premature landing flare by the pilot.NTSB BFO92LA063Accident · No injuriesLimited investigationFinal reportCessna 182M · Vandalia, OHControl interference by a passenger during touchdown.NTSB CHI92LA103Accident · No injuriesLimited investigationFinal reportCessna 182P · Monee, ILThe pilot misjudged the landing flare and touchdown. A related factor was: the dark night light conditions.NTSB LAX92LA048Accident · No injuriesLimited investigationFinal reportCessna 182H · Fortuna, CAThat the pilot misjudged the flare altitude. Contributing to the accident was the failure of the flight instructor to adequately supervise the flight.NTSB LAX91LA372Accident · No injuriesLimited investigationFinal reportCessna 182 · Columbia, CAThe pilot of the aircraft experienced a bounced landing on his initial landing attempt. He executed a go-around and landed without incident on the second attempt. Substantial damage to the firewall was discovered afterwards. The pilot believes the bounced…NTSB CHI91LA253Accident · No injuriesLimited investigationFinal reportCessna 180 · Eveleth, MNThe pilot's failure to maintain the proper descent rate and adequate airspeed during the approach. A factor related to the accident is the lack of recent total experience.NTSB LAX91LA278Accident · No injuriesLimited investigationFinal reportCessna 182Q · Watsonville, CAThe pilot's improper flare and improper recovery from a bounced landing. Factors related to the accident were: gusty winds, the pilot's inadequate compensation for wind conditions, and the pilot's lack of experience in this make and model of aircraft.NTSB BFO91LA057Accident · No injuriesLimited investigationFinal reportCessna 182 · Baltimore, MDThe pilot's improper flare and improper recovery from a bounced landing.NTSB ATL91LA114Accident · No injuriesLimited investigationFinal reportCessna 182R · Dothan, ALLack of supervision by the flight instructor who allowed a dual student to make a hard landing.