NTSB investigations: Cessna 150J
11 cases on aircraft the registry lists as Cessna 150J, where the first occurrence was “Hard landing”. 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 | 2 |
|---|---|
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1998 | 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 ('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\" = 200))
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" = 200))
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 CHI07CA123Accident · Minor injuriesData collectionFinal reportCessna 150J · Amery, WIThe pilot's failure to maintain control of the airplane during the aborted landing attempt which resulted in the airplane impacting trees. A misjudged flare, subsequent bounced landing, and gusty wind conditions were contributing factors.NTSB CHI98LA078Accident · No injuriesLimited investigationFinal reportCessna 150J · Gaylord, MIthe pilot's misjudging the flare leading to a hard landing, and the kit manufacturer's (Supplemental Type Certificate holder's) inadequate design leading to a corrosion stress fracture of the landing gear attachment. A factor was the landing gear attachment…NTSB CHI93LA163Accident · No injuriesLimited investigationFinal reportCessna 150J · Rice Lake, WIThe student pilot's failure to maintain directional control of the airplane.NTSB SEA92LA069Accident · No injuriesLimited investigationFinal reportCessna 150J · Tumwater, WAThe (student) pilot's improper recovery from a bounced landing. Factors contributing to the accident were excessive airspeed and the pilot's lack of total experience.NTSB ATL91LA147Accident · No injuriesLimited investigationFinal reportCessna 150J · Greensboro, NCThe pilot's improper flare during the landing. Factors in the accident were the dark night and lack of runway edge lights.NTSB ATL88LA119Accident · No injuriesLimited investigationFinal reportCessna 150J · Villa Rica, GAAcft was landed to the west on a 2500' dirt strip. Trees, about 25-30' high bounded the approach threshold. Wind was variable nw to w gusting 15-18 KTS. PIC said acft dropped out from under him and landed hard. After bouncing it landed on nose gear which…NTSB DEN87LA109Accident · No injuriesLimited investigationFinal reportCessna 150J · Longmont, COA student plt was practicing landings on her second supervised solo training flt. On the first approach, she failed to flare properly and hit in a three point attitude. The nose gear collapsed and the propeller struck the rwy. The acft skidded about 25 feet…NTSB NYC87LA048Accident · No injuriesLimited investigationFinal reportCessna 150 · Poestenkill, NYThe pilot touched down hard, added power for a go around. Sluggish engine did not have enough power to clear trees at the end of the runway. Aircraft collided with trees. The plt after the acc said that after cutting off the carb head the eng seemed sluggish.…NTSB NYC87LA013Accident · No injuriesLimited investigationFinal reportCessna 150 · So. Dayton, NYThe student pilot came in long and high, bounced the aircraft a few times. The nose wheel collpased and the aircraft was substantially damaged.NTSB CHI82DA344Accident · No injuriesFinal reportCessna 150J · Dekalb, ILThe student pilot was practicing touch-and-go landings. He stated that on about his sixth landing, he touched down hard on the main gear then lowered the nose. As the nose wheel touched down, the aircraft veered to the left and the right wing contacted the…NTSB CHI82DA249Accident · No injuriesFinal reportCessna 150J · Alton, ILThe student and instructor pilot (ip) were departing on an instructional flight. Immediately after takeoff, the ip retarded the throttle to simulate an engine failure. The student lowered the nose to maintain airspeed, then prematurely raised it again. The ip…