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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.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 WPR25LA125Accident · No injuriesClass 4 · LimitedFinal reportCessna 190 · Idaho Falls, IDThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.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 GAA17CA290Accident · No injuriesData collectionFinal reportCessna 190 · Prescott, AZThe pilot’s use of excessive speed during a right turn from the runway to the taxiway, which resulted in a loss of directional control.NTSB CEN12CA429Accident · Minor injuriesData collectionFinal reportCessna 190 · Anthony, NMThe pilot’s failure to maintain directional control during the landing roll.NTSB NYC07CA238Accident · No injuriesData collectionFinal reportCessna 190 · Yulee, FLThe pilot's failure to maintain directional control while landing. A factor in this accident was the crosswind condition.NTSB ATL07CA020Accident · No injuriesData collectionFinal reportCessna 190 · Chattanooga, TNThe pilot's failure to maintain directional control on takeoff resulting in a collapse of the left main landing gear when the airplane swerved. A factor in the accident was wake turbulence from a landing airplane.NTSB MIA03CA083Accident · No injuriesData collectionFinal reportCessna 190 · Lakeland, FLThe pilot's inadequate compensation for wind and his failure to maintain directional control. A related factor was the crosswind.NTSB FTW02LA212Accident · No injuriesLimited investigationFinal reportCessna 190 · Albuquerque, NMThe pilot's failure to maintain aircraft control. A contributing factor was the crosswind.NTSB FTW01FA095Accident · 2 fatalField investigationFinal reportCessna 190 · Lurton, ARthe pilot's continued VFR flight into IMC, which resulted in spatial disorientation and the ensuing loss of aircraft control while in cruise flight. Contributory factors were the haze and fog weather conditions.NTSB ATL99LA124Accident · No injuriesLimited investigationFinal reportCessna 190 · Enterprise, ALThe fatigue failure of the main landing gear spring.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 CHI98LA249Accident · No injuriesLimited investigationFinal reportCessna 190 · Pontiac, MIimproper procedures used during the replacement of the landing gear which resulted in pitting and corrosion of the gear spring.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 FTW95LA191Accident · No injuriesLimited investigationFinal reportCessna 190 · Longmont, COFailure by the pilot-in command-to compensate for crosswind conditions.NTSB MIA94LA082Accident · No injuriesLimited investigationFinal reportCessna 190 · Fort Lauderdale, FLLocking of the right main landing gear brake for undetermined reasons.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 BFO87FA056Accident · 2 fatalField investigationFinal reportCessna 190 · Hedgesville, WVThere were no eyewitnesses to the acdnt, but 3 persons heard the eng rev up to a high power setting before the plane crashed. Subsequently, it crashed in a wooded area north of the plt's 2600' pvt strip. There was a wooded hill north of the strip. The plt's…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 CHI84LA189Accident · No injuriesLimited investigationFinal reportCessna 190 · St. Anne, ILThe plt stated that during his 2nd takeoff from a restricted landing area, the eng hesitated at an alt of about 10 ft AGL. He then aborted the takeoff & tried to land on the remaining rwy. However, the acft touched down in a plowed field where it nosed over.…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 DEN82DA171Accident · No injuriesFinal reportCessna 190 · Bismarck, NDLeft brake failed. Examination revealed the hydraulic brake line to the left brake had pulled loose from a union fitting. The line also sheared by the shifting of the gear box assembly. There were signs of inadequate flare to the tubing in that it pulled out…NTSB ANC82DAG22Accident · Minor injuriesFinal reportCessna 195 · Anchorage, AKThe pilot stated that during the landing roll, at a speed of approximately 30 KTS, the brakes were applied in preparation for turning off the runway. The right brake pedal went to the floor and attempts to pump it up were unsuccessful. The aircraft ran off…NTSB DEN80FTM27Accident · No injuriesClosedCessna 190 · St George, UTNTSB MKC80DER18Accident · No injuriesClosedCessna 190 · Intl Falls, MNNTSB SEA79DYA15Accident · No injuriesClosedCessna 190 · Mccall, IDNTSB OAK79FXQ15Accident · No injuriesClosedCessna 190 · Lake Tahoe, CANTSB LAX77FUQ21Accident · No injuriesClosedCessna 190 · Van Nuys, CANTSB NYC77FHM03Accident · Minor injuriesClosedCessna 195 · Warwick, NYNTSB MIA77FLA02Accident · No injuriesClosedCessna 190 · Live Oak, FLNTSB LAX75DUJ65Accident · No injuriesClosedCessna 195 · Taylor, AZNTSB FTW74FPG75Accident · Minor injuriesClosedCessna 190 · Brinkley, ARNTSB CHI74FEK27Accident · No injuriesClosedCessna 195 · Newark, OHNTSB LAX74AL075Accident · 2 fatalClosedCessna 190 · Hermosa Bch, CANTSB MKC74DCQ19Accident · No injuriesClosedCessna 190 · Bennington, KSNTSB FTW74DRA06Accident · No injuriesClosedCessna 190 · Beaumont, TXNTSB CHI73FEE28Accident · No injuriesClosedCessna 190 · Morris, ILNTSB DEN73FTM04Accident · Minor injuriesClosedCessna 190 · Grouse Creek, UTNTSB SEA72FYC34Accident · No injuriesClosedCessna 190 · Hillsboro, ORNTSB NYC72FNC36Accident · No injuriesClosedCessna 195A · Biddeford, MENTSB MIA72FKG30Accident · No injuriesClosedCessna 190 · Brunswick, GANTSB CHI72FEC07Accident · Serious injuriesClosedCessna 190 · Sans Souci, MINTSB OAK71DVM32Accident · No injuriesClosedCessna 190 · San Jose, CANTSB MIA71FKW10Accident · Minor injuriesClosedCessna 190 · Maryville, TNNTSB FTW70FRA33Accident · No injuriesClosedCessna 190 · Beaumont, TXNTSB NYC70FFG04Accident · Serious injuriesClosedCessna 190 · Pownal, MENTSB MKC69D0316Accident · No injuriesClosedCessna 190 · Osage, IANTSB MKC69F0309Accident · No injuriesClosedCessna 190 · Osage, IANTSB CHI68F0714Accident · No injuriesClosedCessna 190 · Wixom, MI
Back to Cessna 190