Continental 0-200-A
NTSB investigations · 20
Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.engine_model_code IN ('17191')
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.engine_model_code IN ('17191')
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 ERA25LA340Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Jackson, OHThe pilot’s failure to maintain directional control of the airplane during a touch-and-go landing.NTSB WPR24LA301Accident · No injuriesClass 4 · LimitedFinal reportThompson Ryan L Thompson Craft · Port Angeles, WAThe pilot’s failure to maintain directional control during the landing rollout, which resulted in a ground loop.NTSB CEN21LA367Accident · Minor injuriesClass 3 · LimitedFinal reportPulsar Sport 150 · Osceola, WIThe total loss of engine power for undermined reasons based on available informationNTSB CEN20LA397Accident · No injuriesClass 3 · LimitedFinal reportZenith CH 750 · Montgomery City, MOThe pilot’s inadequate fuel management and flight planning, which led to a total loss of engine power due to fuel exhaustion and a forced landing into rough terrain.NTSB CEN15CA061Accident · No injuriesData collectionFinal reportAmerican Champion 7EC · Colorado Springs, COThe loss of airplane control after encountering windshear.NTSB ERA13CA394Accident · No injuriesData collectionFinal reportHoskins Samuel R Quickie Q2 · Zelienople, PAThe pilot's loss of directional control during takeoff due to right main landing gear contact with a pool of standing water on the runway which resulted in a runway excursion.NTSB WPR11CA321Accident · Minor injuriesData collectionFinal reportLeineke Walter L Thorp T-211 · Cedar City, UTThe pilot's misjudgment of the fuel consumption, which lead to fuel exhaustion. Contributing to the accident was the pilot's lack of experience in the accident airplane.NTSB CEN11LA432Accident · Minor injuriesLimited investigationFinal reportBaker Wayne CH-750 · Gladewater, TXA loss of directional control on takeoff for undetermined reasons.NTSB ERA10CA234Accident · No injuriesData collectionFinal reportKramer Clemens E Stol CH750 · Lakeland, FLThe pilot's improper flare, which resulted in a nosegear collapse during landing.NTSB ERA09CA359Accident · No injuriesData collectionFinal reportAircraft Mfg & Development CH 601XL S · Vaughn, MSThe pilot's inadequate preflight planning.NTSB DEN08LA061Accident · No injuriesLimited investigationFinal reportHardy Midget Mustang M-1 · Buena Vista, COThe pilot's failure to maintain directional control. Contributing to the accident was the gusty crosswind.NTSB LAX07CA096Accident · No injuriesData collectionFinal reportPeay Quckie Q-200 · Livermore, CAThe pilot failed to maintain directional control during an aborted takeoff.NTSB LAX07FA026Accident · 2 fatalField investigationFinal reportAircraft Mfg & Dev. CH601XL Slsa · Yuba City, CAIn-flight structural failure of the horizontal stabilizer and wings for undetermined reasons.NTSB ANC04LA013Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Anchorage, AKThe pilot's misjudged altitude during final approach, which resulted in an undershot landing, and subsequent nose over.NTSB CHI01LA282Accident · No injuriesLimited investigationFinal reportHoskins Quickie Q2 · Carbondale, ILThe failure of the tailwheel spring. A factor was the directional control not possible by the pilot.NTSB CHI86FER15Accident · No injuriesFinal reportSamuel R. Hoskins Q-200 · Eden Prairie, MNAircraft was being test flown following ground adjustment of rudder control cables. During the flight rudder control was lost when rudder bearing blocks detached from their mounting surfaces. Pilot was unable to maintain directional control during landing…NTSB MIA78DLA07Accident · Minor injuriesClosedCessna 150 · Whigham, GANTSB FTW74FPG24Accident · Serious injuriesClosedAeronca 7BC · Lake Village, ARNTSB NYC71FHG08Accident · No injuriesClosedCessna 150 · New Cumberland, PANTSB DEN70F0131Accident · Minor injuriesClosedCessna 150J · Las Cruces, NM
Back to Continental 0-200-A