NTSB investigations: Continental 0-300 series, TX
214 cases on aircraft whose registry engine model is Continental 0-300 series. 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, 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_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\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17022'))
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" = 'TX' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17022'))
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 FTW99LA009Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Conroe, TXThe pilot's failure to maintain clearance with trees. Factors were the fogged front windshield and side windows.NTSB FTW98LA318Accident · No injuriesLimited investigationFinal reportCessna 172H · Commerce, TXThe pilot's inadequate compensation for the crosswind resulting in a loss of control. A factor was the crosswind.NTSB FTW98LA133Accident · No injuriesLimited investigationFinal reportCessna 172D · El Paso, TXThe pilots improper compensation for the wind conditions and his failure to maintain control of the aircraft. A factor was the high wind condition.NTSB FTW96LA207Accident · Minor injuriesLimited investigationFinal reportBowers Midget Mustang M-1 · Mesquite, TXThe pilot's failure to maintain aircraft control following the separation of the propeller spinner installed by the pilot. A factor was the pilot's failure to obtain the required FAA inspection for the installation.NTSB FTW95LA352Accident · No injuriesLimited investigationFinal reportCessna 172E · Alpine, TXThe failure of the pilots of both airplanes to see and avoid each other. A factor was the Cessna's inoperative radio.NTSB FTW95LA062Accident · No injuriesLimited investigationFinal reportCessna 172B · Seguin, TXThe pilot's failure to attain proper touchdown point.NTSB FTW93LA209Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Longview, TXThe pilot's failure to follow procedures.NTSB FTW93LA202Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Lampasas, TXFuel exhaustion engine power loss due to an inadequate preflight preparation. A factor was the lack of suitable terrain for the forced landingNTSB FTW93LA184Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Canyon Lake, TXThe movement of the pilot's seat aft which resulted in his loss of control, his inability to regain control, and the ensuing inadvertent stall. A factor was the inadequate inspection of the airplane.NTSB FTW93LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Hamlin, TXThe pilot's failure to switch fuel tanks and his failure to perform the prescribed emergency procedures following the fuel starvation induced engine failure. A factor was the lack of suitable terrain for the emergency landing.NTSB FTW92LA216Accident · No injuriesLimited investigationFinal reportCessna 172C · Weatherford, TXFuel starvation as result of a blocked fuel vent system. A factor was the lack of suitable terrain for the forced landing.NTSB FTW92LA192Accident · No injuriesLimited investigationFinal reportCessna 172 · Vernon, TXAircraft control not maintained by pilot. A factor was unfavorable wind.NTSB FTW92LA082Accident · No injuriesLimited investigationFinal reportCessna 172B · Golden, TXFuel exhaustion due to the pilot's failure to refuel. Factors were false fuel sensor indications and a fence.NTSB FTW90LA105Accident · No injuriesLimited investigationFinal reportCessna 172H · San Angelo, TXThe student failed to maintain directional control of the aircraft during takeoff in variable wind conditions.NTSB FTW89LA027Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Plano, TXFuel exhaustion which resulted from the pilot's inadequate fuel consumption calculations and his failure to utilize numerous suitable sources of fuel along his route of flight.NTSB FTW88LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Leona, TXThe plt planned his apch to land about 1000 ft down the 3400 ft dirt rwy because the first 1000 ft was wet and soft. The last 400 ft was also wet and soft. The wind was calm and the apch speed was high. During the flare, the acft ballooned and floated past…NTSB FTW88LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Midland, TXThe pilot landed long and could not stop before running off the end of the runway. The aircraft, collided with a fence and the left wing was damaged when the acft collided with a ditch.NTSB FTW87LA167Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Quitman, TXDuring final approach for landing, the pilot allowed the airspeed to drop. The aircraft stalled at approximately 30 to 40 feet AGL. Substantial damage occurred when the aircraft bounced, cartwheeled and slid to a stop backwards 300 feetbeyond the threshold.NTSB FTW87LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Amarillo, TXAfter landing, the pilot attempted to taxi the aircraft to the ramp when he encountered strong gusty winds. The passenger and four linemen attempted to hold the aircraft down, but the winds blew the aircraft over inverted causing substantial damage.NTSB FTW87FA022Accident · Minor injuriesField investigationFinal reportCessna 172C · Amarillo, TXThe certificated stu plt of the citabria was making touch and go landings at the uncontrolled arpt when the accident occurred. He took off to the south flying a left hand traffic pattern. The base to final turn was made aprx 1/4 mile from the rwy in front of…NTSB FTW86LA155Accident · No injuriesLimited investigationFinal reportCessna 172A · Gainesville, TXThe pilot was taxiing into position for takeoff, when there was a wind shift and a gust of wind inverted the aircraft. The pilot had not obtained any weather reports prior to taxiing out to the runway. There were thunderstorms in the area and a heavy rain…NTSB FTW86LA038Accident · No injuriesLimited investigationFinal reportCessna 172G · Spring, TXThe pilot continued VFR flight into IFR weather conditions which he had encountered near his destination during the last few moments of his approximate four hour, night, cross-country flight. He then turned back to houston intercontinental airport to land. He…NTSB FTW86LRA03Accident · No injuriesFinal reportCessna 172F · Saratoga, TXPilot was enroute from rocksprings, TX. To hardin county airport near kountz, TX. As pilot appoached Saratoga, TX., the engine quit due to fuel exhaustion. Pilot landed in field near Saratoga causing substantial damage to the aircraft. No injuries were…NTSB FTW84LA397Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Flatonia, TXThe plt stated he applied full power to the eng as he started his takeoff run on rwy 15. He applied forward pressure on the control yoke to raise the tail and the acft started to drift left. The rt wing hit a tree and the acft continued into a lake.NTSB FTW84LA311Accident · No injuriesLimited investigationFinal reportCessna 175A · Daisetta, TXThe student plt on a solo flt ran off the end of the rwy during landing. FAA said the plt had not received dual instruction recently enough to be legally qualified for this flt. A report of the accident was not filed by the student.NTSB FTW83LA395Accident · No injuriesLimited investigationFinal reportCessna 172H · Plano, TXThe acft collided with 2 parked acft after the student plt lost control during landing. The plt stated that he experienced a crosswind gust or updraft during touchdown. The landing was on rwy 16 and the wind was estimated to be from 220 degrees at 12 KTS. The…NTSB FTW83FA362Accident · 3 fatalField investigationFinal reportCessna 172F · El Paso, TXTwo plts & 2 passengers departed san angelo, TX, on a x-country flt, one of the plts, who had 95 hrs of flying time, was the pilot-in-command (PIC) for the 1st leg of the x-country to El Paso, TX. On the next leg, the other plt assumed duties as PIC & signed…NTSB FTW83LA348Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Marshall, TXThe aircraft collided with an unmarked pile of dirt off the appraoch end of the runway at the harrison county airport. The runway was being extended and 5 1/2 to 6 foot tall mounds of fill dirt were left in the approach path of the runway. The pilot stated he…NTSB FTW83LA203Accident · No injuriesLimited investigationFinal reportCessna 172B · Spearman, TXThe acft swerved off the right side of the rwy and collided with a ditch. The acft nose gear collapsed during the sequence. The landing was on rwy 20 and during the approach the plt noticed that the wind was out of the south and that the wind sock was…NTSB FTW83LA344Accident · No injuriesLimited investigationFinal reportCessna 172D · New Braunfels, TXThe acft made a hard landing which was hard enough to blow the nose gear tire and collapse the nose gear assembly.NTSB FTW82DA379Accident · Minor injuriesFinal reportCessna 172 · Corpus Christi, TXAircraft landed short after engine quit on final approach. The fuel was down to minimum usable quantity.NTSB FTW82DA333Accident · No injuriesFinal reportCessna 172F · Springlake, TXThe student pilot reported that during a landing, he flared too high. The aircraft then stalled onto the runway and was substantially damaged. Reportedly, he had a 3 kt tail wind and the density altitude was about 6000 ft.NTSB FTW82DA039Accident · No injuriesFinal reportCessna 172 · Fruit Vale, TXThe pilot stated that during the approach he was momentarily blinded by the sun. The aircraft collided with the top wire on a fence at the end of the runway pulling it down onto the runway.NTSB FTW82FA030Accident · 1 fatalClosedCessna 172 · Venus, TXNTSB FTW81FRA45Accident · Minor injuriesClosedCessna 172 · Palacios, TXNTSB FTW80DQG07Accident · No injuriesClosedCessna 172 · Spearman, TXNTSB FTW80DRG12Accident · No injuriesClosedCessna 170 · Johnson City, TXNTSB FTW79DQG19Accident · No injuriesClosedCessna 172H · Crosbyton, TXNTSB FTW79FA013Accident · 1 fatalClosedCessna 172H · Kent, TXNTSB FTW79DQG06Accident · Minor injuriesClosedCessna 172 · Andrews, TXNTSB FTW79FPD04Accident · No injuriesClosedCessna 172F · Pilot Point, TXNTSB FTW79FA001Accident · 1 fatalClosedCessna 172 · Bridgeport, TXNTSB FTW78FPD17Accident · No injuriesClosedCessna 172A · Brownwood, TXNTSB FTW78DQD16Accident · No injuriesClosedCessna 172G · Imperial, TXNTSB FTW78FPD04Accident · No injuriesClosedCessna 172 · Jacksboro, TXNTSB FTW77FRA36Accident · No injuriesClosedCessna 172F · Pearland, TXNTSB FTW77DQG12Accident · No injuriesClosedCessna 170B · Plainview, TXNTSB FTW76DRG80Accident · No injuriesClosedCessna 172H · Lowake, TXNTSB FTW76DPD43Accident · No injuriesClosedCessna 170 · Weatherford, TXNTSB FTW76DRA36Accident · No injuriesClosedCessna 150M · Sugarland, TX