NTSB investigations: Cessna 190, CA
14 cases on aircraft the registry lists as Cessna 190. 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
| 1967 | 2 |
|---|---|
| 1970 | 1 |
| 1974 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1989 | 2 |
| 1998 | 2 |
| 2021 | 1 |
| 2024 | 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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072902'))
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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072902'))
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 ANC24LA036Accident · No injuriesClass 3 · LimitedFinal reportCessna 190 · San Luis Obispo, CAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a failure of the right main landing gear and subsequent ground loop.NTSB WPR21LA126Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 190 · Camarillo, CAThe failure of the pilot to maintain directional control of the airplane during the landing roll which resulted in a runway excursion and subsequent nose over.NTSB LAX99LA007Accident · Minor injuriesLimited investigationFinal reportCessna 190 · Lost Hills, CAA loss of engine power due to fatigue failure of the number 4 cylinder articulating rod.NTSB LAX98LA074Accident · No injuriesLimited investigationFinal reportCessna 195 · Long Beach, CAThe pilot's failure to maintain directional control during the landing, which led to a ground loop and a resultant overload failure of the right main landing gear attach points.NTSB LAX89LA205Accident · No injuriesLimited investigationFinal reportCessna 190 · Livermore, CAThe failure of the flight instructor to maintain directional control. Contributing to the accident was the flight instructors lack of experience in this type aircraft.NTSB LAX89LA089Accident · No injuriesLimited investigationFinal reportCessna 190 · Sonoma, CAA jammed brake mechanism resulting in the pilot's inability to maintain directional control.NTSB LAX87LA154Accident · No injuriesLimited investigationFinal reportCessna 190 · Chino, CAPrior to takeoff the pilot observed an asymmetrical deflection of the rudder/brake pedals. Upon landing he executed a right turn to depart the runway. The pilot stated that he was unable to stop the right turn and the aircraft ground looped damaging the left…NTSB LAX84FA255Accident · 1 fatalField investigationFinal reportFolke Wulf 1903A · Livermore, CAThe acft crashed after stalling during the initial climb after takeoff. The plt had called on the radio to say he was 'going to come back around.' When asked by the tower if he wwas declaring an emergency he did not answer. The acft reportedly was making a…NTSB OAK79FXQ15Accident · No injuriesClosedCessna 190 · Lake Tahoe, CANTSB LAX77FUQ21Accident · No injuriesClosedCessna 190 · Van Nuys, CANTSB LAX74AL075Accident · 2 fatalClosedCessna 190 · Hermosa Bch, CANTSB OAK71DVM32Accident · No injuriesClosedCessna 190 · San Jose, CANTSB LAX67F0386Accident · No injuriesClosedCessna 195 · Torrance, CANTSB OAK68F0050Accident · Minor injuriesClosedCessna 190 · San Jose, CA