NTSB investigations: Cessna 150G
27 cases on aircraft the registry lists as Cessna 150G, where the first occurrence was “Loss of control - on ground/water”. 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
| 1983 | 2 |
|---|---|
| 1984 | 2 |
| 1985 | 2 |
| 1987 | 1 |
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 3 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 2 |
| 2003 | 1 |
| 2005 | 1 |
| 2006 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071816')
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\" = 260))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071816')
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" = 260))
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 CHI06CA170Accident · No injuriesData collectionFinal reportCessna 150G · Indianapolis, INThe pilot intentionally leaving the airplane unoccupied during the engine start and the failure of the tail tie-down, which ultimately resulted in the unoccupied airplane becoming airborne.NTSB NYC05CA090Accident · No injuriesData collectionFinal reportCessna 150G · Willimantic, CTThe student pilot's improper recovery from a bounced landing and his failure to maintain directional control while landing.NTSB NYC03LA073Accident · No injuriesLimited investigationFinal reportCessna 150G · Medina, OHThe pilot's failure to follow published procedures while starting the engine, and his failure to maintain control of the airplane.NTSB CHI99LA195Accident · No injuriesLimited investigationFinal reportCessna 150G · Fort Scott, KSThe pilot's failure to maintain directional control during the landing roll. A factor to the accident was the soft terrain condition.NTSB NYC99LA084Accident · No injuriesLimited investigationFinal reportCessna 150 · Leonardtown, MDThe pilot's failure to maintain control of the airplane during a crosswind landing.NTSB SEA98LA053Accident · No injuriesLimited investigationFinal reportCessna 150G · Hailey, IDA fractured nosewheel steering linkage bolt, which permitted the nosewheel steering linkage to become disconnected, and the student pilot's subsequent failure to restore directional control by use of differential wheel braking.NTSB LAX97LA234Accident · No injuriesLimited investigationFinal reportCessna 150G · Barstow, CAThe student pilot's inability to attain directional control of the aircraft due to an improperly adjusted parking brake spring.NTSB CHI97LA064Accident · No injuriesLimited investigationFinal reportCessna 150G · Dowagiac, MIthe pilot's failure to maintain directional control. A factor was the snowbank.NTSB LAX96LA125Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Auburn, CAfailure of the pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve.NTSB NYC96LA042Accident · No injuriesLimited investigationFinal reportCessna 150G · East Hampton, NYfailure of the flight instructor to adequately supervise the dual student pilot and ensure that directional control of the airplane was maintained. The icy runway was a related factor.NTSB CHI95LA156Accident · No injuriesLimited investigationFinal reportCessna 150G · Stockton, MOthe pilot's inadequate compensation for the crosswind weather condition and subsequent failure to maintain directional control. Factors were the crosswind and the ditch.NTSB SEA95LA002Accident · No injuriesLimited investigationFinal reportCessna 150 · Florence, ORThe pilot-in-command's failure to properly recover from a bounced landing, and his failure to compensate for wind conditions and maintain directional control during the landing rollout. Contributing to the accident were gusty crosswinds.NTSB CHI94LA035Accident · No injuriesLimited investigationFinal reportCessna 150G · Neosho, MOThe pilot-in-command's failure to maintain directional control during landing rollout.NTSB LAX92LA370Accident · No injuriesLimited investigationFinal reportCessna 150G · Woodland, CAThe failure of the pilot to maintain directional control of the aircraft during the landing roll. Factors in the accident were the students lack of total experience and the soft nature of the recently plowed field the aircraft encountered.NTSB SEA92LA085Accident · No injuriesLimited investigationFinal reportCessna 150G · Caldwell, IDThe pilot in command's failure to maintain directional control. Factors contributing to the accident were: crosswinds and gusts.NTSB ANC92LA047Accident · No injuriesLimited investigationFinal reportCessna 150G · Juneau, AKThe pilot failed to maintain directional control during the landing roll.NTSB LAX92LA066Accident · No injuriesLimited investigationFinal reportCessna 150G · Point Mugu, CAThe pilot's disregard of the available wind information. Contributing to this accident was a high tail wind.NTSB FTW91LA134Accident · No injuriesLimited investigationFinal reportCessna 150G · Marietta, OKThe pilot's failure to maintain directional control. A factor was his attempt to takeoff without using all available runway.NTSB NYC91LA111Accident · No injuriesLimited investigationFinal reportCessna 150G · Phillipsburg, OHThe failure of the pilot to compensate for crosswind conditions during landing, and allowing the airplane to drift off the runway onto soft terrain. A factor relating to the accident was the decision of the pilot to attempt a landing with strong crosswinds.NTSB CHI91LA049Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Monroe, MIDirectional control not maintained by the PIC.NTSB FTW87LA140Accident · Minor injuriesLimited investigationFinal reportCessna 150G · College Station, TXThe pilot stated that upon touchdown the aircraft began to shake so violently that he could not see the panel or control the aircraft. During landing roll it veered off the left side of the runway. The nose and right main gear wheels dug into the soft ground…NTSB MKC86LA042Accident · No injuriesLimited investigationFinal reportCessna 150 · Carlisle, ARThe student plt was making the takeoff, after a stop and go landing. The acft began to drift to the lt during the roll and the CFI cautioned the student to correct for torque. The CFI took control but was unable to get the student to release the controls…NTSB FTW85LA145Accident · No injuriesLimited investigationFinal reportCessna 150G · Miami, OKStudent pilot was on a solo cross country flight from siloam springs ar. To Miami, ark. And return. The pilot had landed at Miami previously. He had started his takeoff run when a wind gust caused the aircraft to veer left. The aircraft went off the runway…NTSB LAX84LA456Accident · No injuriesLimited investigationFinal reportCessna 150G · Apple Valley, CAThe student was receiving instruction in soft field landings & rudder control during the landing roll-out. A downwind approach was made to rwy 18 which had a downward gradient of 1.5%. Flaps were used for the approach & the acft touched down about 1/3 of the…NTSB FTW84LA351Accident · No injuriesLimited investigationFinal reportCessna 150 · Pecos, TXThe pilot stated that he got lost while on a x-country from big springs, TX, to van horn, TX. The pilot made a landing at a ranch strip to ask directions. After touchdown, the acft veered to the left in a crosswind. One main landing gear and both wings were…NTSB FTW84LA065Accident · No injuriesLimited investigationFinal reportCessna 150G · Mcallen, TXThe acft groundlooped during landing and collided with a ditch. This acft had been converted to conventional landing gear. The plt had only 1 hour as PIC in this configuration of landing gear equipment.NTSB CHI83LA128Accident · No injuriesLimited investigationFinal reportCessna 150D · Wilmington, OHThe aircraft operated by a student pilot swerved off the runway during a touch and go landing and nosed over. The pilot had been practicing touch and go landing for about 40 minutes preceding the accident. During the last landing he toucheddown in a crab and…