NTSB investigations: Continental C145 series
126 cases on aircraft whose registry engine model is Continental C145 series, where the first occurrence was “Loss of control - on ground/water”. 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 | 6 |
|---|---|
| 1983 | 14 |
| 1984 | 6 |
| 1985 | 3 |
| 1986 | 5 |
| 1987 | 10 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 6 |
| 1991 | 4 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 2 |
| 1995 | 3 |
| 1996 | 7 |
| 1997 | 7 |
| 1998 | 9 |
| 1999 | 5 |
| 2000 | 4 |
| 2001 | 1 |
| 2002 | 4 |
| 2003 | 2 |
| 2004 | 3 |
| 2005 | 4 |
| 2006 | 4 |
| 2007 | 3 |
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 ('17012')
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\" = 260))
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 ('17012')
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" = 260))
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 NYC08CA003Accident · No injuriesData collectionFinal reportCessna 170A · Wadesboro, NCThe pilot's improper recovery from a bounced landing.NTSB NYC07CA135Accident · No injuriesData collectionFinal reportCessna C-170A · Trenton, GAThe pilot's failure to maintain directional control during the landing roll which resulted in an impact with trees. Factors in the accident were the uneven narrow runway, and a wind gust.NTSB MIA07CA104Accident · No injuriesData collectionFinal reportCessna 170B · Pahokee, FLThe pilot's failure to maintain directional control during a crosswind landing.NTSB NYC06LA216Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Hampton, NHThe pilot's failure to maintain directional control during takeoff.NTSB MIA06CA100Accident · No injuriesData collectionFinal reportCessna 170B · Fort Pierce, FLThe failure of the pilot-in-command to maintain directional control during the landing roll.NTSB LAX06CA145Accident · No injuriesData collectionFinal reportCessna 170B · Redlands, CAthe student's inadequate compensation for the crosswind gust and failure to maintain directional control. Also causal was the flight instructor's inadequate supervision of the flight, and his failure to maintain directional control. A factor was control…NTSB MIA06CA082Accident · No injuriesData collectionFinal reportCessna C170A · Lakeland, FLThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB ANC05CA083Accident · No injuriesData collectionFinal reportCessna 170B · Anchorage, AKThe pilot's inadequate compensation for the wind conditions during the landing roll, which resulted in a loss of control and an inadvertent ground-loop. A factor associated with the accident was a crosswind.NTSB ANC05LA081Accident · No injuriesLimited investigationFinal reportCessna 170B · Ninilchick, AKThe pilot's failure to maintain control of the airplane during the landing roll on a beach, which resulted in an on-ground collision with terrain. A factor associated with the accident is a tailwind.NTSB ANC05LA076Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKThe pilot's inadequate compensation for wind conditions, which resulted in a loss of control during the landing roll. Factors associated with the accident are a crosswind, and an inadvertent ground loop/swerve.NTSB ANC05LA074Accident · No injuriesLimited investigationFinal reportCessna 170B · Homer, AKThe flight instructor's inadequate supervision of the flight during the landing roll, which resulted in a loss of control, and collision with a ditch. A factor associated with the accident was the student pilot's failure to maintain directional control.NTSB ANC04CA094Accident · No injuriesData collectionFinal reportCessna 170B · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll due to the restricted movement of the rudder pedals from his headset cord, which resulted in the airplane exiting the runway and nosing down.NTSB ANC04LA062Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop and subsequent structural damage to the airplane when it struck the runway.NTSB SEA04LA072Accident · No injuriesLimited investigationFinal reportCessna 170B · Nampa, IDThe right seat pilot's failure to maintain directional control during the initial part of the landing roll, and his improper handling of the aircraft (excessive braking) as the aircraft departed the side of the runway. Factors include the pilot's lack of…NTSB ANC03LA087Accident · No injuriesLimited investigationFinal reportCessna 170 · Anchorage, AKThe pilot's inadequate compensation for a crosswind condition and his failure to maintain directional control of the airplane that resulted in the left wing contacting the runway surface during the landing roll. Factors contributing to the accident were the…NTSB DEN03LA060Accident · No injuriesLimited investigationFinal reportCessna 170A · Hobbs, NMthe pilot's failure to maintain aircraft directional control during takeoff roll. A factor was the runway light's cement foundation.NTSB FTW03LA074Accident · No injuriesLimited investigationFinal reportCessna 170A · West Helena, ARThe pilot's failure to maintain directional control during landing. A contributing factor was the deflated tire.NTSB LAX02LA245Accident · No injuriesLimited investigationFinal reportCessna 170B · St. Johns, AZthe pilot's selection of the wrong runway for the existing crosswind condition and his subsequent inadequate compensation for the winds, which led to a failure to maintain directional control and a ground loop.NTSB ANC02LA032Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe failure of the pilot to maintain directional control during takeoff. A factor associated with the accident was an inadvertent ground loop.NTSB ATL02LA080Accident · No injuriesLimited investigationFinal reportCessna 170B · Ocala, FLThe pilot's failure to maintain directional control on landing roll, resulting in a loss of control/ground loop.NTSB MIA01LA116Accident · No injuriesLimited investigationFinal reportCessna 170B · Penrose, NCfailure of the pilot to maintain directional control of the aircraft during the landing rollout while landing in a crosswind which resulted in a ground swerve and substantial damage to the aircraft.NTSB FTW00LA249Accident · No injuriesLimited investigationFinal reportCessna 170A · Mexia, TXThe pilot's inadequate compensation for wind conditions. Factors were the gusty crosswind and the pilot's failure to perform a go-around upon encountering a windshift/crosswind.NTSB SEA00LA164Accident · No injuriesLimited investigationFinal reportCessna 170B · Nampa, IDThe pilot's failure to maintain directional control during the balked landing.NTSB ANC00LA077Accident · No injuriesLimited investigationFinal reportCessna 170B · Wasilla, AKThe pilot's failure to maintain directional control during landing. A factor associated with the accident is the pilot's excessive use of the brakes.NTSB DEN00LA087Accident · No injuriesLimited investigationFinal reportCessna 170B · Bedford, WYThe pilot's inadvertent ground loop. A factor was the soft grass airstrip.NTSB ATL00LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Oakland, ALThe pilot's failure to verify that his seat was locked prior to takeoff. The subsequent bounce on takeoff enabled the seat to shift aft thereby reducing the pilot's access to controls leading to the inadvertent loss of control and ground impact with trees.…NTSB LAX00LA029Accident · No injuriesLimited investigationFinal reportCessna 170A · El Mirage, CAThe pilot's failure to maintain directional control of his airplane, which resulted in an inadvertent ground loop.NTSB SEA99LA128Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Spokane, WAThe pilot's failure to maintain directional control. A related factor was the pilot's lack of experience in tailwheel aircraft.NTSB DEN99LA115Accident · No injuriesLimited investigationFinal reportCessna 170 · Durango, COThe pilot's failure to maintain directional control of the aircraft during landing roll. A factor was the high density altitude and the high vegetation (sagebrush).NTSB CHI99LA106Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Grand Ledge, MIthe flight instructor's failure to successfully take remedial action to maintain directional control of the airplane during the landing roll out. Factors were the crosswinds and snowbank.NTSB MIA99LA049Accident · No injuriesLimited investigationFinal reportCessna 170 · Lawrenceville, GAThe pilot's failure to maintain directional control.NTSB ANC98LA136Accident · No injuriesLimited investigationFinal reportCessna 170A · North Pole, AKThe student pilot's inadvertent ground loop/swerve during the landing roll.NTSB ATL98LA106Accident · No injuriesLimited investigationFinal reportCessna 170 · Pell City, ALThe pilot's improper use of the flight controls during a crosswind landing and the improper recovery from a bounce resulted in the collapse of the right main landing gear. A factor was the right crosswind.NTSB ANC98LA050Accident · No injuriesLimited investigationFinal reportCessna 170B · Russian Mission, AKThe pilot's inadequate compensation for wind conditions while landing. A factor associated with the accident was the presence of a tailwind condition.NTSB FTW98LA251Accident · No injuriesLimited investigationFinal reportCessna 170B · Los Alamos, NMThe pilot's inadequate compensation for the wind conditions. Contributing factors were the crosswinds, the fence, and the ditch.NTSB IAD98LA066Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Wadsworth, OHThe flight instructor's failure to maintain control of the airplane which resulted in his intentional ground loop. A factor in the accident was the flight instructor's lack of currency in tailwheel airplanes.NTSB FTW98LA237Accident · No injuriesLimited investigationFinal reportCessna 170A · Provo, UTfailure of the pilot to maintain directional control of the airplane. A related factor was the right quartering tailwind gust.NTSB SEA98LA075Accident · No injuriesLimited investigationFinal reportCessna 170 · Auburn, WAThe pilot's inadequate compensation for gusty crosswind conditions. A related factor was gusty crosswinds.NTSB ANC98LA028Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKThe pilot-in-command's decision to relinquish controls to the student pilot in the left seat during practice landings, and the pilot-in-command's failure to maintain directional control. A factor contributing to this accident was the pilot-in-command's lack…NTSB LAX98LA011Accident · No injuriesLimited investigationFinal reportCessna 170A · Quincy, CAloss of directional control due to a severe tail wheel vibration, which was induced by an improperly installed and adjusted tail wheel assembly.NTSB FTW97LA372Accident · No injuriesLimited investigationFinal reportCessna 170A · Oklahoma City, OKThe pilot's inadequate compensation for the crosswind conditions resulting in an inadvertent groundloop. Factors were the crosswind, the pilot's lack of total experience in make and model, the separation of the left main wheel due to corroded bolts, and the…NTSB ANC97LA130Accident · No injuriesLimited investigationFinal reportCessna 170A · Iliamna, AKthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control of the airplane, which resulted in a ground swerve and overload failure of the right main landing gear. Factors related to the accident were: the…NTSB SEA97LA160Accident · No injuriesLimited investigationFinal reportCessna 170B · Jackson, WYThe pilot's inadequate compensation for wind conditions. Gusting wind conditions was a factor.NTSB IAD97LA091Accident · No injuriesLimited investigationFinal reportAeronca S15AC · Laconia, NHThe pilot's inadequate compensation for a crosswind, which resulted in the loss of aircraft control. A factor in the accident was the gusting winds.NTSB ANC97LA067Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. A factor relating to the accident was: the crosswind.NTSB ANC97LA059Accident · No injuriesLimited investigationFinal reportCessna 170 · Delta Junction, AKfailure of the pilot to maintain directional control of the airplane.NTSB CHI97LA043Accident · No injuriesLimited investigationFinal reportCessna 170B · Savoy, ILthe student pilot's failure to maintain directional control. Factors relating to this accident were the student pilot's failure to request another runway and the crosswind.NTSB LAX97LA055Accident · No injuriesLimited investigationFinal reportCessna 170A · El Cajon, CAfailure of the pilot to maintain directional control, which resulted in a ground swerve. The pilot's low total time in conventional gear aircraft was a related factor.NTSB LAX96LA333Accident · No injuriesLimited investigationFinal reportCessna 170B · Concord, CAThe pilot's failure to maintain directional control. The 40-degree crosswind component was a factor in this accident.NTSB ANC96LA104Accident · No injuriesLimited investigationFinal reportCessna 170B · Tyonek, AKThe pilot's failure to maintain directional control during the landing roll.