NTSB investigations: Cessna 150K
13 cases on aircraft the registry lists as Cessna 150K, 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
| 1986 | 1 |
|---|---|
| 1987 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1995 | 1 |
| 1997 | 2 |
| 2004 | 1 |
| 2007 | 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 ('2071822')
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 ('2071822')
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 ANC07LA028Accident · No injuriesLimited investigationFinal reportCessna 150 · Willow, AKThe student pilot's failure to maintain directional control while taxiing, which resulted in the airplane contacting a snow berm and nosing down. Factors associated with the accident were the snow and ice covered runway, and excessive taxispeed.NTSB SEA04LA176Accident · No injuriesLimited investigationFinal reportCessna 150K · Richland, WAThe pilot's failure to maintain aircraft control during landing. Wind gusts, inadequate compensation for wind conditions, and an airport marker sign were factors.NTSB MIA97LA167Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Ball Ground, GAfailure of the pilot to maintain directional control during the takeoff roll and his failure to abort the takeoff before colliding with an embankment.NTSB SEA97LA042Accident · No injuriesLimited investigationFinal reportCessna 150K · Helena, MTThe pilot's failure to maintain directional control.NTSB CHI95LA115Accident · No injuriesLimited investigationFinal reportCessna 150 · Table Rock, NEthe pilot's failure to maintain directional control during an aborted takeoff. Factors related to the accident were the crosswind conditions and the berm which the airplane contacted.NTSB NYC93LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Hagerstown, MDThe failure of the flight instructor to adequately supervise the student pilot, and take control of the airplane in a timely manner which resulted in the airplane departing the runway and striking a tower. Factors related to the accident were the improper use…NTSB CHI92LA083Accident · No injuriesLimited investigationFinal reportCessna 150 · Lansing, MIFailure of the pilot to maintain directional control of the airplane during a takeoff ground run. Factors associated with the accident are the pilot's diverted attention, his lack of total experience, and the soft terrain.NTSB CHI92LA078Accident · No injuriesLimited investigationFinal reportCessna 150 · New Haven, MIDirectional control was not maintained by the dual student and remedial action was delayed by the CFI. A factor related to the accident was the icy runway conditions.NTSB CHI91LA268Accident · No injuriesLimited investigationFinal reportCessna 150 · St. Clair, MODirectional control was not maintained by the pilot.NTSB MKC90LA074Accident · No injuriesLimited investigationFinal reportCessna 150 · Hyannis, NEFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and a subsequent nose over. Factors related to the accident were: the pilot's lack of experience in this aircraft, and the soft terrain.NTSB FTW88LA043Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Woodworth, LAThe plt stated that during landing roll the aircraft veered left due to a strong wind gust. The aircraft fell into a ravine, coming to rest 180 degrees from the runway heading, damaging both wing spars at the fuselage attach points and collapsing the nose…NTSB ATL88LA063Accident · No injuriesLimited investigationFinal reportCessna 150K · Portland, TNThe student plt rptd that the airplane veered off the rt side of the rwy into a ditch while ldg in x-wind conditions. The student plt estimated that the wind velocity was 10 KTS with gusts to 20 KTS. The student rptdly had about 32 hrs total flt experience,…NTSB NYC86LA209Accident · No injuriesLimited investigationFinal reportCessna 150 · Springfield, VTThe plt lost directional control of the acft during takeoff run. The acft traveled off the side of the rwy into tall grass and nosed over. The plt stated that he may have pressed the brake pedal inadvertently instead of the rudder.