NTSB investigations: Continental 0-200 series

136 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “In flight collision with object”. 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17020')
      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\" = 220))
  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.

NTSB IAD96LA151Accident · 1 fatalLimited investigationFinal reportCessna 150C · Liberty, KYthe pilot's failure to maintain adequate altitude, while maneuvering at a low altitude, which resulted in in-flight collision with trees.Sep 23, 1996 · N1947Z · DestroyedNTSB IAD96LA076Accident · 2 fatalLimited investigationFinal reportCessna 150 · Welch, WVthe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain sufficient altitude to clear obstacles. A factor was his intentional buzzing.May 10, 1996 · N6303S · DestroyedNTSB FTW96LA096Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Mandeville, LAthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his failure to maintain sufficient altitude/clearance from obstructions (power lines) at night.Jan 15, 1996 · N714JV · Substantial damageNTSB ATL95LA085Accident · No injuriesLimited investigationFinal reportCessna 150H · Bath, NCA bird, which collided with and fractured the aircraft windshield, resulting in an emergency landing. A factor was the soft terrain at the emergency landing site.Apr 16, 1995 · N7025S · Substantial damageNTSB CHI95LA101Accident · No injuriesLimited investigationFinal reportCessna 150 · Ann Arbor, MIthe pilot's failure to maintain directional control of the airplane during the aborted landing. Factors associated with the accident were the airport sign and the night lighting conditions.Mar 15, 1995 · N63671 · Substantial damageNTSB CHI95LA077Accident · No injuriesLimited investigationFinal reportCessna 150F · Castlewood, SDthe pilot's inadequate preflight planning and preparation. Factors associated with the accident are the snow covered/drifted runway, and a fence.Jan 21, 1995 · N8981S · Substantial damageNTSB FTW95LA042Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Seguin, TXThe pilot's failure to attain a proper climb rate after takeoff. A factor was the dark night light condition.Nov 11, 1994 · N9237U · Substantial damageNTSB NYC95LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Dawson Springs, KYThe pilot's failure to maintain adequate obstacle clearance. Other related factors are night conditions and the pilot's improper inflight planning/decision.Nov 9, 1994 · N5483Q · Substantial damageNTSB CHI95LA033Accident · No injuriesLimited investigationFinal reportCessna 150 · Tomahawk, WIthe collision with deer during landing - flare/touchdown.Nov 9, 1994 · N9143U · Substantial damageNTSB CHI94LA229Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Watersmeet, MIthe pilot's failure to maintain control of the airplane, and his inadequate preflight planning and preparation. Factors associated with the accident were the fog and the trees.Jul 13, 1994 · N6579G · DestroyedNTSB BFO94LA089Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Troy, NYThe pilot's inadequate compensation for the wind conditions and failure to maintain alignment with the runway which resulted in an inflight collision with a tree. A factor is crosswinds.Jun 4, 1994 · N2480J · DestroyedNTSB SEA94LA031Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Kirkland, WAThe pilot in command's failure to maintain clearance with the tree. A factor contributing to the accident was the pilot in command's ostentatious display.Nov 13, 1993 · N2446J · DestroyedNTSB SEA93LA157Accident · No injuriesLimited investigationFinal reportCessna 150L · Ontario, ORThe pilot in command's failure to maintain proper clearance. A factor contributing to the accident was the pilot in command's delayed go around.Jul 10, 1993 · N10050 · Substantial damageNTSB CHI93LA183Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Flora, ILthe delayed remedial action by the flight instructor. A factor related to the accident was the lack of total experience in this type operation by the flight instructor.May 27, 1993 · N714AN · Substantial damageNTSB CHI93LA168Accident · No injuriesLimited investigationFinal reportCessna 150L · Washington, MOThe pilot's failure to maintain proper runway alignment.May 13, 1993 · N10011 · Substantial damageNTSB FTW93LA091Accident · No injuriesLimited investigationFinal reportCessna 150H · Adkins, TXThe student pilot's failure to maintain clearance while maneuvering. A factor was the student's diverted attention from the open engine inspection doorFeb 20, 1993 · N6623S · Substantial damageNTSB NYC92FA185Accident · 1 fatalField investigationFinal reportCessna 150F · Lake Neepaulin, NJAn inflight collision with trees after the pilot failed to outclimb the terrain. Factors related to the accident were the pilot's improper use of the flaps and the pilot's decision to operate the airplane over the maximum allowable gross weight.Sep 13, 1992 · N8725G · Substantial damageNTSB ATL92LA155Accident · No injuriesLimited investigationFinal reportCessna 150L · Manteo, NCThe delayed level off by the pilot, during the banner pick-up, which resulted in the entanglement of the banner with the horizontal stabilizer.Aug 9, 1992 · N11912 · Substantial damageNTSB SEA92FA148Accident · 1 fatalField investigationFinal reportCessna 150 · Burns, ORThe failure of the pilot to maintain clearance from wires on a 500 kv electrical power transmission line.Jul 11, 1992 · N5988E · DestroyedNTSB FTW92LA177Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Grove, OKThe pilot failed to maintain aircraft contyrol. A factor was turbulence.Jul 7, 1992 · N3562J · Substantial damageNTSB LAX92LA095Accident · No injuriesLimited investigationFinal reportCessna 150J · Pinyon, CAThe flight instructor's inadequate in-flight planning to enter a mountainous area at a low altitude, and his improper handling of the airplane. Factors which contributed to the accident related to the instructor's lowering of the wing flaps during a time when…Jan 19, 1992 · N50810 · Substantial damageNTSB MIA92LA057Accident · 1 fatalLimited investigationFinal reportWalter R. Penney VARI-EZE · Lamar, MSThe pilot in commands departure into and continued flight in instrument meteorological conditions while operating under visual flight rules resulting in an inflight collision with trees and then the ground.Jan 8, 1992 · N12WP · DestroyedNTSB SEA91LA230Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Dixie, IDThe pilot's failure to maintain adequate clearance with tree(s) during the initial climb. Factors contributing to the accident were the high density altitude and downdraft conditions.Sep 1, 1991 · N5934E · DestroyedNTSB ATL91FA110Accident · 1 fatalField investigationFinal reportCessna 150J · Monroe, GAThe pilots attempted flight in adverse weather and the physical impairment of the student pilot from the consumption of alcoholic beverages prior to flight. A factor in the accident was the foggy weather condition at the airport.Jun 15, 1991 · N60466 · Substantial damageNTSB CHI91LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Mccook, NEA poorly planned approach and inadequate visual lookout by the pilot.Apr 23, 1991 · N32478 · 2 aircraft · Substantial damageNTSB FTW91LA021Accident · Serious injuriesLimited investigationFinal reportCessna 150E · Amarillo, TXAn underpowered takeoff attempt due to incorrectly set magnetos. Contributing was the transmission lines.Dec 7, 1990 · N3956U · DestroyedNTSB SEA90FA182Accident · 1 fatalField investigationFinal reportCessna 150M · Prospect, ORThe pilot's failure to maintain a proper altitude during his approach. The dark night condition was a contributing factor.Sep 14, 1990 · N3420V · DestroyedNTSB MIA90LA179Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Geneva, FLThe pilots failure to retract the flaps to the takeoff setting during a touch-and-go landing.Sep 6, 1990 · N61133 · Substantial damageNTSB CHI90LA179Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia, MOInadequate visual outlook by the PIC.Jul 20, 1990 · N16088 · Substantial damageNTSB LAX90LA192Accident · No injuriesLimited investigationFinal reportCessna 150F · Franklin, CAThe fixed base operator mechanic used improper bolt/nut during repair of the elevator system.May 20, 1990 · N27G · Substantial damageNTSB ATL90FA109Accident · 1 fatalField investigationFinal reportCessna 150L · Stockbridge, GAThe pilot's failure to maintain the proper clearance from objects on the ground.May 5, 1990 · N10790 · DestroyedNTSB MKC90LA052Accident · No injuriesLimited investigationFinal reportCessna 150 · Clear Lake, MNFailure of the pilot to maintain proper alignment with the runway, his delay in initiating a go-around, and his premature raising of the flaps. Factors related to the accident were the adverse wind conditions and the tree.Feb 9, 1990 · N7359G · Substantial damageNTSB NYC90LA070Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Duanesburg, NYThe failure of the flight instructor to adequately monitor the actions of the student pilot and apply corrective action in a timely manner.Feb 8, 1990 · N4768X · Substantial damageNTSB MKC89LA138Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Grain Valley, MOFailure of the student pilot to maintain proper runway alignment, while aborting a bounced landing. Factors related to the accident were: the pilot's improper flare and lack of experience in the make and model of aircraft, the right crosswind, and the…Jun 19, 1989 · N3148V · Substantial damageNTSB ATL89LA155Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Trinity, NCThe pilots failure to select a suitable takeoff area based on the weight of the aircraft and the atmospheric conditions at the time of takeoff.May 30, 1989 · N1115T · Substantial damageNTSB ATL89LA137Accident · No injuriesLimited investigationFinal reportCessna 150F · Jacksonville, NCThe pilot's failure to properly preflight and plan which resulted in a collision with trees. The pilot attempted a takeoff with an over gross weight condition.Apr 26, 1989 · N8260F · DestroyedNTSB LAX89LA138Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Mesa, AZInadequate visual lookout by the pilot, and his failure to maintain the proper altitude. Factors related to the accident were: the pilot's lack of visual perception at dusk, the transmission line, and the obstructions (tree & fence) in the emergency landing…Mar 29, 1989 · N7592U · Substantial damageNTSB MKC89FA060Accident · 1 fatalField investigationFinal reportCessna 150K · Pemberton, MNPoor judgement on the part of the pilot in that he attempted a down wind take off without adequate distance to clear obstacles in his flight path.Feb 22, 1989 · N6010G · Substantial damageNTSB NYC89LA079Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Hammonton, NJA bird strike shortly after takeoff.Feb 4, 1989 · N6299K · Minor damageNTSB LAX89LA066Accident · No injuriesLimited investigationFinal reportCessna 150L · Hesperia, CAAt the end of a pleasure flight, while on final approach, the airplane was low on the approach. Just prior to reaching the airport boundary, the airplane collided with the top of a vehicle travelling on a road perpendicular to the runway. The airplane…Dec 22, 1988 · N1542Q · Substantial damageNTSB DEN89LA044Accident · No injuriesLimited investigationFinal reportCessna 150E · Basin, WYThe private plt attempted a takeoff from his short farm field strip. During the takeoff ground run, the plt realized the acft would not have flying speed and clear the fence at the end of the field. He elected to try to jump the acft over the fence and land…Dec 17, 1988 · N6122T · Substantial damageNTSB NYC88LA240Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Burlington, CTThe plt was attempting to land at the mountain arpt. Patwas indicated the winds were from the north at 15 KTS. Gusts were not reported. The plt made her apch at 70 mph IAS and with 20 deg of flaps deployed. As she flared the acft, she encountered a gust of…Sep 24, 1988 · N3099X · Substantial damageNTSB MKC88FA166Accident · Serious injuriesField investigationFinal reportCessna 150 · Reed Springs, MOThe accident aircraft was observed performing high speed passes at extremely low altitude over the lake. Witnesses estimated the altitude of the aircraft from 30 to 75 feet above the water. The aircraft struck 72,000 volt power lines at a point approximately…Aug 29, 1988 · N3475V · Substantial damageNTSB FTW88LA157Accident · No injuriesLimited investigationFinal reportCessna 150M · Killeen, TXAccording to the pilot/operator aircraft accident report, the private pilot had not flown in the previous 90 days. The pilot was practicing landings on a dark night and collided with power lines 1000 feet short of the runway. After colliding with the wires,…Aug 29, 1988 · N704SB · DestroyedNTSB SEA88LA152Accident · 1 fatalLimited investigationFinal reportCassutt III · Shelton, WAAcft had been restored and recertificated since last flight in 1969. On initial test flight takeoff, plt immediately turned to and flew low, slow landing pattern circuit with sounds of reduced power, colliding with trees in final approach turn. Investigation…Aug 13, 1988 · N2984G · DestroyedNTSB MKC88FA086Accident · 1 fatalField investigationFinal reportCessna 150F · Mansfield, MOA witness saw the acft flying at low alt as it passed in front of her car at dusk in a northeasterly drctn. She rprtd the acft contd down a valley toward power lines that spanned an open field. She saw the acft pull up rapidly, become entangled in the power…May 9, 1988 · N8605S · Substantial damageNTSB MIA88FA071Accident · 1 fatalField investigationFinal reportCessna 150H · Destin, FLWitnesses stated that they observed the acft flying in the fog in a southeasterly direction and turn hard right just before it struck the 19th floor of a condominium. The fog according to residents of the bldg was so thick that the ground could not be seen…Dec 24, 1987 · N7005S · DestroyedNTSB ATL87LA149Accident · No injuriesLimited investigationFinal reportCessna 150M · Dahlonega, GAThe acft impacted trees and a hillside shortly after a night takeoff from rwy 33 while the CFI was flying the acft from the rt seat. The CFI reported that he intended to fly the pattern to demonstrate a ldg to his student. During initial climb, he lost sight…May 26, 1987 · N704YK · Substantial damageNTSB BFO87LA038Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Selbyville, DEDuring takeoff the pilot stated that at about 150 to 200 feet he experienced a slow sinking of the aircraft. The engine was at full throttle, the flaps set at 10 degrees and the airspeed at 70 knots. The aircraft continued to sink and collided with trees.…May 16, 1987 · N5747G · DestroyedNTSB LAX87LA205Accident · No injuriesLimited investigationFinal reportCessna 150M · Honolulu, HIThe student and CFI landed at ford island and the CFI deplaned to observe the student perform solo landings. The studentexecuted one takeoff and landing without incident. On the second approach the student elected to make a go-around. He used full flaps for…May 14, 1987 · N704QH · Substantial damage