NTSB investigations: Continental 0-200 series
115 cases on aircraft whose registry engine model is Continental 0-200 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 | 9 |
|---|---|
| 1983 | 4 |
| 1984 | 6 |
| 1985 | 7 |
| 1986 | 8 |
| 1987 | 6 |
| 1988 | 5 |
| 1989 | 7 |
| 1990 | 2 |
| 1991 | 4 |
| 1992 | 1 |
| 1993 | 5 |
| 1994 | 6 |
| 1995 | 3 |
| 1996 | 5 |
| 1997 | 7 |
| 1998 | 11 |
| 1999 | 5 |
| 2002 | 2 |
| 2003 | 4 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 4 |
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 ('17020')
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 ('17020')
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 LAX08CA012Accident · No injuriesData collectionFinal reportCessna 150M · Hillsboro, ORThe pilot's misjudged and delayed landing flare that resulted in a hard landing and porpoise down the runway. Contributing factors in the accident were the night conditions and the optical illusion created by the narrow runway width and upsloping terrain.NTSB CHI07CA192Accident · No injuriesData collectionFinal reportCessna 150M · Muncie, INThe pilot's failure to maintain sufficient airspeed, resulting in a stall/mush during an attempted aborted landing. A factor in the accident was the premature flare and the pilot's inadequate recovery from a bounced landing.NTSB CHI07CA123Accident · Minor injuriesData collectionFinal reportCessna 150J · Amery, WIThe pilot's failure to maintain control of the airplane during the aborted landing attempt which resulted in the airplane impacting trees. A misjudged flare, subsequent bounced landing, and gusty wind conditions were contributing factors.NTSB DFW07CA083Accident · No injuriesData collectionFinal reportCessna 150 · Sand Springs, OKThe pilot's improper recovery from a bounced landing.NTSB DFW06CA120Accident · Minor injuriesData collectionFinal reportCessna 150L · Levelland, TXThe pilot's misjudged landing flare and his improper recovery from a bounced landing.NTSB NYC06CA094Accident · No injuriesData collectionFinal reportCessna 150M · Hazleton, PAThe student pilot's improper recovery from a bounced landing, resulting in a hard landing.NTSB CHI05CA252Accident · No injuriesData collectionFinal reportCessna 150E · Durand, WIThe inadequate flare during landing by the pilot. A contributing factor was the lack of certification of the pilot.NTSB CHI05CA127Accident · No injuriesData collectionFinal reportCessna 150F · Neodesha, KSThe student pilot's misjudgment of the landing flare resulting in a hard landing, his inadequate recovery from the bounced landing and his subsequent failure to maintain directional control of the airplane. The pilot's attempt to abort the landing, and the…NTSB LAX04LA247Accident · No injuriesLimited investigationFinal reportCessna 150M · Tucson, AZthe pilot's misjudged flare and improper recovery from a bounced landing, which resulted in a pilot induced porpoise/oscillation.NTSB DEN04LA028Accident · No injuriesLimited investigationFinal reportCessna 150H · Bountiful, UTthe unqualified person's failure to maintain aircraft control, which resulted in a hard landing. Contributing factors include the instructor's inadequate supervision, the instructor's inadequate recovery from a bounced landing, and the two parked aircraft.NTSB CHI03LA054Accident · No injuriesLimited investigationFinal reportCessna 150M · Charleston, MOthe inadequate flare by the pilot. Factors were the loose trim tab cable for undetermined reasons.NTSB MIA03CA041Accident · Serious injuriesData collectionFinal reportCessna 150K · Everglades City, FLThe instructor's failure to maintain airspeed during climb after lift off from an aborted landing, resulting in the airplane stalling, entering a spin, and crashing into water at the departure end of the runway. Contributing to the accident was the…NTSB CHI02LA153Accident · No injuriesLimited investigationFinal reportCessna 150C · Minneapolis, MNThe pilot's improper flare resulting in the hard landing.NTSB NYC02LA095Accident · Serious injuriesLimited investigationFinal reportCessna 152M · Forest, VAThe student pilot's improper flare and failure to recover from a bounced landing, which resulted in a nose over.NTSB CHI99LA354Accident · No injuriesLimited investigationFinal reportCessna 150L · Midland, MIthe student pilot's failure to maintain control of the airplane during an attempted go-around.NTSB DEN99LA143Accident · No injuriesLimited investigationFinal reportMoore Q-200 · Cortez, COThe pilot's improper recovery from a bounced landing and his failure to maintain directional control. Related factors were the soft wet terrain.NTSB FTW99LA193Accident · No injuriesLimited investigationFinal reportCessna 150M · Beaumont, TXThe student pilot's excessive rate of descent resulting in the hard landing and his improper recovery from a bounced landing.NTSB LAX99LA239Accident · No injuriesLimited investigationFinal reportCessna 150K · Hesperia, CAThe pilot's misjudged landing flare point and failure to maintain an adequate airspeed margin, resulting in a stall and hard landing.NTSB FTW99LA082Accident · No injuriesLimited investigationFinal reportCessna 150M · Baton Rouge, LAThe pilot's failure to maintain an adequate approach airspeed which resulted in a excessive descent rate and hard landing and the pilot's failure to recover from a bounced landing. A factor was the pilot's lack of total experience.NTSB ATL99LA022Accident · No injuriesLimited investigationFinal reportCessna 150 · Winnsboro, SCThe pilot's improper landing flare that resulted in overload damage to the nose wheel assembly.NTSB CHI99LA025Accident · No injuriesLimited investigationFinal reportCessna 150M · Warrensburg, MOthe student pilot's inadequate flare and his failure to maintain directional control of the airplane. Factors associated with the accident were, the student's lack of total experience and the dirt bank which was contacted.NTSB MIA99LA021Accident · No injuriesLimited investigationFinal reportCessna 150F · Winter Haven, FLThe student pilot's improper landing flare resulting in a hard landing and ground loop.NTSB IAD99LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Clinton, MDThe student pilot's improper flare and improper recovery from a bounced landing.NTSB FTW98LA403Accident · No injuriesLimited investigationFinal reportCessna 150M · Yukon, OKThe pilot's improper landing flare which resulted in a hard landing and her improper recovery procedures for a bounced landing.NTSB IAD98LA098Accident · No injuriesLimited investigationFinal reportCessna 150L · Cumberland, MDThe pilot in command's improper recovery from a bounced landing.NTSB SEA98LA129Accident · No injuriesLimited investigationFinal reportCessna 150 · Oregon City, ORThe pilot's improper flare.NTSB FTW98LA147Accident · No injuriesLimited investigationFinal reportCessna 150L · Conway, ARThe pilot's improper landing flare which resulted in a hard landing and her improper recovery procedures for a bounced landing.NTSB FTW98LA102Accident · Serious injuriesLimited investigationFinal reportMartin Varieze · Artesia, NMThe pilot's inadequate compensation for the crosswind. Factors were the prevailing crosswind and the pilot's lack of total experience in type of aircraft.NTSB LAX98LA080Accident · No injuriesLimited investigationFinal reportCessna 150F · San Carlos, CAThe pilot's excessive airspeed, which resulted in a bounced landing, and, his failure to ensure that his seat locking pin was engaged, which caused his seat to move backwards during the touchdown and resulted in his loss of directional control.NTSB CHI98LA078Accident · No injuriesLimited investigationFinal reportCessna 150J · Gaylord, MIthe pilot's misjudging the flare leading to a hard landing, and the kit manufacturer's (Supplemental Type Certificate holder's) inadequate design leading to a corrosion stress fracture of the landing gear attachment. A factor was the landing gear attachment…NTSB CHI98LA069Accident · No injuriesLimited investigationFinal reportCessna 150L · Litchfield, MNthe pilot's improper flare and improper recovery from a bounced landing, and his failure to maintain proper runway alignment during the attempted go-around. Factors relating to the accident were: the crosswind condition, and the proximity of trees.NTSB IAD98LA013Accident · No injuriesLimited investigationFinal reportCessna 150L · Center Village, OHThe student pilot's improper recovery from a bounced landing.NTSB CHI97LA296Accident · No injuriesLimited investigationFinal reportCessna 150M · Salem, ILthe student pilot's improper flare and improper recovery from a bounced landing.NTSB ANC97LA119Accident · No injuriesLimited investigationFinal reportTaylorcraft TC-19 · Anchorage, AKThe pilot's excessive descent rate during a touch-and-go landing, which resulted in damage to the landing gear and inability to control the airplane during a subsequent landing. A factor was his lack of total experience in tailwheel-equipped airplanes.NTSB MIA97LA170Accident · No injuriesLimited investigationFinal reportCessna 150F · Venice, FLfailure of the pilot to maintain sufficient airspeed on final approach and during the landing to properly flare the airplane.NTSB FTW97LA164Accident · No injuriesLimited investigationFinal reportCessna 150F · Norman, OKImproper flare.NTSB MIA97LA114Accident · No injuriesLimited investigationFinal reportCessna 150G · St. Petersburg, FLthe student pilot's improper level off.NTSB FTW96LA376Accident · No injuriesLimited investigationFinal reportCessna 150M · Boulder, COan improper flare by the student pilot, and his improper recovery from a bounced landing. A factor relating to the accident was: the student pilot's lack of experience in the type (model) of aircraft.NTSB FTW96LA347Accident · No injuriesLimited investigationFinal reportCessna 150H · Fort Collins, COimproper flare by the pilot, which resulted in a hard landing, and subsequent overload failure of the nosewheel axle and nose gear.NTSB MIA96LA196Accident · No injuriesLimited investigationFinal reportCessna 150M · Knightdale, NCthe student pilot's improper recovery from a bounced landing by applying power and slight nose up elevator input.NTSB SEA96LA150Accident · No injuriesLimited investigationFinal reportCessna 150 · Puyallup, WAimproper flare by the pilot during a touch-and-go landing.NTSB NYC96LA120Accident · No injuriesLimited investigationFinal reportCessna 150L · Matawan, NJthe student pilot's improper flare and improper recovery from a bounced landing. The gusty wind condtion was a related factor.NTSB FTW96LA029Accident · No injuriesLimited investigationFinal reportCessna 150L · Norman, OKThe student pilot's improper recovery from a bounced landing and the flight instructor's inadequate supervision of the flight. Factors were the gusty wind conditions and the student pilot's failure to obtain and maintain proper compensation for the wind…NTSB MIA95LA146Accident · No injuriesLimited investigationFinal reportCessna 150G · Archer, FLThe pilot's improper landing flare/touchdown resulting in a hard/bounced landing, and subsequent nose over. Contributing to the accident was the pilot's improper recovery from a bounced landing.NTSB MIA95LA096Accident · No injuriesLimited investigationFinal reportCessna 150K · Hattiesburg, MSThe failure of the pilot-in-command to perform a recovery from a bounced landing, resulting in a hard landing and subsequent collapsing of the nose gear.NTSB MIA94LA201Accident · No injuriesLimited investigationFinal reportMankovich Parakeet · Fernandina Bch, FLThe improper flare by the pilot-in-command resulting in the hard landing, and the pilot's failure to perform a recovery from the bounced landing. Contributing to the accident was the pilot's lack of total time in this type airplane.NTSB BFO94LA115Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Orrington, METhe pilot misjudged his altitude and airspeed which resulted in a hard landing. Related factors were the soft, and upslope field.NTSB MIA94LA151Accident · No injuriesLimited investigationFinal reportCessna 150H · Sugarloaf Key, FLThe improper flare and improper recovery from a bounced landing by the pilot-in-command.NTSB CHI94LA184Accident · No injuriesLimited investigationFinal reportCessna 150M · Concordia, KSthe pilot-in-command's misjudging of the altitude of the airplane and his diversion of attention during the landing. A factor was the improper use of the throttle by the pilot-in-command.NTSB BFO94LA080Accident · No injuriesLimited investigationFinal reportCessna 150L · Farmingdale, NJThe student pilot's improper flare and the flight instructor's inadequate supervision.