NTSB investigations: Cessna 150J
17 cases on aircraft the registry lists as Cessna 150J, 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
| 1982 | 1 |
|---|---|
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1991 | 4 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 1 |
| 2000 | 1 |
| 2003 | 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 ('2071820')
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 ('2071820')
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 CHI07CA029Accident · No injuriesData collectionFinal reportCessna 150J · South Haven, MIThe pilot's inadequate compensation for the crosswind during landing. Factors were the crosswind and the ditch.NTSB IAD03LA034Accident · No injuriesLimited investigationFinal reportCessna 150J · Williamson, NYThe pilot's failure to maintain proper runway alignment during the takeoff roll. A factor was the snow-covered runway.NTSB DEN00LA128Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Spanish Fork, UTThe pilot in command's failure to maintain aircraft directional control.NTSB MIA96LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150J · New Port Richey, FLFailure of the pilot to maintain directional control of the airplane, while landing with a crosswind, which resulted in an inadvertent ground swerve. A factor relating to the accident was: the pilot's lack of recent flying experience.NTSB CHI95LA102Accident · No injuriesLimited investigationFinal reportCessna 150 · West Fargo, NDthe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor associated with the accident was the soft terrain that the airplane encountered.NTSB SEA94LA114Accident · No injuriesLimited investigationFinal reportCessna 150K · Chehalis, WAThe pilot's inadequate compensation for wind conditions. A factor to the accident was: crosswind.NTSB CHI94LA135Accident · No injuriesLimited investigationFinal reportCessna 150J · Fredricktown, MOthe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the crosswind.NTSB BFO93LA111Accident · No injuriesLimited investigationFinal reportCessna 150 · Pittsfield, MELoss of the tail wheel steering due to undetermined reason(s).NTSB CHI92LA147Accident · No injuriesLimited investigationFinal reportCessna 150 · Greenbay, WIA fractured rod end bolt which resulted in an unsteerable nosewheel.NTSB FTW91LA156Accident · No injuriesLimited investigationFinal reportCessna 150J · Tomball, TXAn improper recovery from a bounced landing.NTSB NYC91LA204Accident · No injuriesLimited investigationFinal reportCessna 150J · Burgettstown, PAThe pilot-in-command's failure to maintain control of the airplane on the landing roll, resulting in an on ground collision with a tree. Factors related to the accident was the pilot's improper use of the brake system.NTSB SEA91LA096Accident · No injuriesLimited investigationFinal reportCessna 150J · Mulino, ORThe pilot's inadequate remedial action. Factors include nose-gear vibration.NTSB NYC91LA089Accident · No injuriesLimited investigationFinal reportCessna 150J · Angola, NYThe failure of the pilot to insure the magneto switch was off prior to moving the propeller.NTSB MKC88LA065Accident · No injuriesLimited investigationFinal reportCessna 150J · Searcy, ARWhile landing in direct crosswind, the PIC lost directional control during the roll out. The acft veered off the runway, damaging the right wing tip and empennage. The pilot stated he thought a gust of wind caused the loss of control.NTSB ATL87LA214Accident · No injuriesLimited investigationFinal reportCessna 150J · Higginsport, OHThe pilot reported that the aircraft skidded off the runway into a piece of parked farm equipment. The sod runway surface was wet. The pilot further reported that the right wing rose and the a/c veered off the runway. The pilot was unable to maintain…NTSB DEN85LA105Accident · No injuriesLimited investigationFinal reportCessna 150 · Logan, UTThe acft departed the rwy during a touch and go landing. The plt stated that after touchdown, the acft pulled to the right. The acft impacted a snowbank to adjacent to the rwy and nosed over. It was reported that the plt had applied wheel brakes with the…NTSB MKC82DA048Accident · No injuriesFinal reportCessna 150 · Sabetha, KSThe pilot initiated a landing approach to runway 1 with the wind from 280 degrees at 18, gusting 25 knots. He entered final approach in a crab and was lined up with the runway. When over the threshold, the plane started to drift right. It settled to the…