NTSB investigations: Cessna 150L
28 cases on aircraft the registry lists as Cessna 150L, 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 | 1 |
|---|---|
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 3 |
| 1991 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 4 |
| 1999 | 1 |
| 2006 | 2 |
| 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 ('2071826')
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 ('2071826')
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 DFW07CA083Accident · No injuriesData collectionFinal reportCessna 150 · Sand Springs, OKThe pilot's improper recovery from a bounced landing.NTSB MIA06CA112Accident · No injuriesData collectionFinal reportCessna 150L · Crystal River, FLThe student pilot's improper recovery from a bounced landing.NTSB DFW06CA120Accident · Minor injuriesData collectionFinal reportCessna 150L · Levelland, TXThe pilot's misjudged landing flare and his improper recovery from a bounced landing.NTSB CHI99LA354Accident · No injuriesLimited investigationFinal reportCessna 150L · Midland, MIthe student pilot's failure to maintain control of the airplane during an attempted go-around.NTSB ATL99LA022Accident · No injuriesLimited investigationFinal reportCessna 150 · Winnsboro, SCThe pilot's improper landing flare that resulted in overload damage to the nose wheel assembly.NTSB IAD99LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Clinton, MDThe student pilot's improper flare and improper recovery from a bounced landing.NTSB IAD98LA098Accident · No injuriesLimited investigationFinal reportCessna 150L · Cumberland, MDThe pilot in command's improper recovery from a bounced landing.NTSB FTW98LA147Accident · No injuriesLimited investigationFinal reportCessna 150L · Conway, ARThe pilot's improper landing flare which resulted in a hard landing and her improper recovery procedures for a bounced landing.NTSB CHI98LA069Accident · No injuriesLimited investigationFinal reportCessna 150L · Litchfield, MNthe pilot's improper flare and improper recovery from a bounced landing, and his failure to maintain proper runway alignment during the attempted go-around. Factors relating to the accident were: the crosswind condition, and the proximity of trees.NTSB IAD98LA013Accident · No injuriesLimited investigationFinal reportCessna 150L · Center Village, OHThe student pilot's improper recovery from a bounced landing.NTSB NYC96LA120Accident · No injuriesLimited investigationFinal reportCessna 150L · Matawan, NJthe student pilot's improper flare and improper recovery from a bounced landing. The gusty wind condtion was a related factor.NTSB FTW96LA029Accident · No injuriesLimited investigationFinal reportCessna 150L · Norman, OKThe student pilot's improper recovery from a bounced landing and the flight instructor's inadequate supervision of the flight. Factors were the gusty wind conditions and the student pilot's failure to obtain and maintain proper compensation for the wind…NTSB BFO94LA080Accident · No injuriesLimited investigationFinal reportCessna 150L · Farmingdale, NJThe student pilot's improper flare and the flight instructor's inadequate supervision.NTSB CHI91LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Winona, MNImproper flare performed by the pilot. A factor related to the accident was lack of total experience by the pilot.NTSB ANC89LA089Accident · No injuriesLimited investigationFinal reportCessna 150-L · Alexander River, AKThe failure of the pilot to land at the proper touchdown point and the resulting hard landing. Damage to the airplane precluded a go-around and resulted in the intentional swerve into a River to avoid injuries to people on the ground.NTSB ATL89LA120Accident · No injuriesLimited investigationFinal reportCessna 150L · Bowling Green, OHThe student pilot failed to maintain control of the aircraft when he misjudged the height of the landing flare. The recovery from the bounced landing was inadequate and the nose gear collapsed upon impact with the runway.NTSB NYC89LA070Accident · No injuriesLimited investigationFinal reportCessna 150L · Shirley, NYA poorly planned final approach, an improper landing flare, and failure of the pilot to correct a bounced landing.NTSB CHI88LA066Accident · No injuriesLimited investigationFinal reportCessna 150L · Springfield, ILThe aircraft experienced a hard landing followed by collapse of the nose gear. The student pilot stated that he bounced on his first attempt to land and the second touchdown was nose first which resulted in the collapse of the nose gear.NTSB ATL88LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Cumming, GAThe student pilot was attempting to land on the 1550 foot runway. The aircraft touched down hard and bounced. The pilot pushed forward on the control column and the aircraft came down on the nose gear which collapsed.NTSB MIA86LA105Accident · No injuriesLimited investigationFinal reportCessna 150L · St. ThomasThe student plt was on a supervised solo flt practicing to & ldgs. On the last ldg, the wind caught the acft & the plt attempted to recover without adding power. Control of the acft was lost & the plt attempted to force the acft back onto the rwy. The acft…NTSB DEN86LA084Accident · No injuriesLimited investigationFinal reportCessna 150L · Watford City, NDThe acft made a hard landing on rwy 30 at Watford City muni arpt, ND, and was substantially damaged. The student plt said the accident occurred on the third touch-and-go. The plt said he used only 10 degrees of flaps. He noted some turbulence and an increase…NTSB CHI86LA020Accident · No injuriesLimited investigationFinal reportCessna 150L · Ashland, OHThe student pilot was on his second solo flt after he made six landings with his instructor. On the third touch and go the acft hit hard, bounced, stalled, and contacted the rwy in a nose down attitude. The student plt attempted recovery from the hard landing…NTSB FTW85LA279Accident · No injuriesLimited investigationFinal reportCessna 150L · Killeen, TXThe student pilot failed to properly flare the aircraft and touched down hard on the nose gear. This caused the aircraft to start porpoising from which recovery was not made. Aircraft continued to bounce until the nose gear collapsed. It then slid to a stop,…NTSB CHI85LA208Accident · No injuriesLimited investigationFinal reportCessna 150L · Necedah, WIAfter a flt with an instructor, the student took off on a solo flt. During a touch & go the student stated, '... I came in high & fast. I landed long and the aircraft bounced twice. I then panicked and pushed the control forward causing the nose to dive into…NTSB NYC84LA167Accident · No injuriesLimited investigationFinal reportCessna 150 · Hampton, NHPilot stated that while landing, the aircraft bounced once possibly two times. On final touch down, the nose landing gear collapsed and the aircraft nosed over onto its back.NTSB FTW84LA229Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Seymour, TXThe 27 hour student plt aborted his landing when the acft began to balloon. The plt retracted the flaps and the acft settled hard onto the rwy and bounced back into the air. The plt reacted by pulling back on the yoke and inadvertently applied left aileron…NTSB MKC84LA085Accident · No injuriesLimited investigationFinal reportCessna 150L · Ft Riley, KSThe student plt stated he landed hard, bounced and impacted the rwy again, collapsing the nose gear.NTSB DEN82DA095Accident · No injuriesFinal reportCessna 150 · Dillon, MTWhile the student pilot was landing, the aircraft bounced and nosed over. The pilot had only 4 hours of solo time.