NTSB investigations: Cessna 150F, KS
30 cases on aircraft the registry lists as Cessna 150F. 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
| 1965 | 1 |
|---|---|
| 1966 | 6 |
| 1967 | 4 |
| 1968 | 7 |
| 1969 | 1 |
| 1970 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1986 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 2005 | 1 |
| 2009 | 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.\"eventStateOrRegion\" = 'KS' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071814'))
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."eventStateOrRegion" = 'KS' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071814'))
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 CEN09CA552Accident · No injuriesData collectionFinal reportCessna 150F · Abilene, KSThe pilot's inadequate crosswind landing technique, resulting in an excessive side load on the left landing gear that led to an overload failure of its axle.NTSB CHI05CA127Accident · No injuriesData collectionFinal reportCessna 150F · Neodesha, KSThe student pilot's misjudgment of the landing flare resulting in a hard landing, his inadequate recovery from the bounced landing and his subsequent failure to maintain directional control of the airplane. The pilot's attempt to abort the landing, and the…NTSB MKC90LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Wichita, KSFuel exhaustion due to poor planning and the pilot's failure to refuel the aircraft.NTSB MKC88LA115Accident · No injuriesLimited investigationFinal reportCessna 150 · Trousdale, KSDuring a cross country personal flight, the PIC noticed an excessively high oil temperature. He said he enriched the fuel mixture, and when that failed to cool the engine, he reversed his course back to his departure apt. Shortly after his reversal of course,…NTSB MKC88LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Manhattan, KSWhile practicing short field ldgs at night, the pilot stated he felt he stalled on final about 15 to 20 feet above the runway. The aircraft bounced three times, striking each wing on the first two touchdowns and collapsing the nose gear assembly on the last…NTSB MKC87LA016Accident · No injuriesLimited investigationFinal reportCessna 150F · Louisburg, KSThe instructor stated that he had observed the student visually check the fuel supply bu that he did not personally inspect the tanks, assuming they were full. According to the pilot, his only confirmation of full tanks was the students repeated statements…NTSB MKC81DCQ46Accident · No injuriesClosedCessna 150 · Coldwater, KSNTSB MKC80DCQ34Accident · No injuriesClosedCessna 150 · Mcpherson, KSNTSB MKC76DCH01Accident · No injuriesClosedCessna 150 · Kansas City, KSNTSB MKC75DCG20Accident · No injuriesClosedCessna 150 · Olathe, KSNTSB MKC70DCG29Accident · No injuriesClosedCessna 150 · Eudora, KSNTSB MKC69F0336Accident · No injuriesClosedCessna 150E · Johnson, KSNTSB MKC69D0260Accident · No injuriesClosedCessna 150 · Kansas City, KSNTSB MKC69D0230Accident · No injuriesClosedCessna 150 · Alma, KSNTSB MKC69D0021Accident · No injuriesClosedCessna 150 · Eureka, KSNTSB MKC68D0542Accident · No injuriesClosedCessna 150F · Oswego, KSNTSB MKC68D0544Accident · No injuriesClosedCessna 150 · Lawrence, KSNTSB MKC68F0449Accident · Minor injuriesClosedCessna 150 · Kansas City, KSNTSB MKC68D0413Accident · No injuriesClosedCessna 150 · Smith Center, KSNTSB MKC68D0374Accident · No injuriesClosedCessna 150F · Severy, KSNTSB MKC68D0387Accident · No injuriesClosedCessna 150 · Olathe, KSNTSB MKC67D0594Accident · No injuriesClosedCessna 150 · Lawrence, KSNTSB MKC67F0418Accident · No injuriesClosedCessna 150 · Lawrence, KSNTSB MKC67F0424Accident · Serious injuriesClosedCessna 150F · Ft.Riley, KSNTSB MKC67D0342Accident · No injuriesClosedCessna 150 · Olathe, KSNTSB MKC67D0227Accident · No injuriesClosedCessna 150 · Wellington, KSNTSB MKC67D0163Accident · No injuriesClosedCessna 150 · El Dorado, KSNTSB MKC66F0562Accident · No injuriesClosedCessna 150 · Kansas City, KSNTSB MKC66F0409Accident · No injuriesClosedCessna 150 · Emporia, KSNTSB NYC66F0224Accident · Minor injuriesClosedCessna 150F · Gardner, KS