NTSB investigations: Cessna 150H, KS
17 cases on aircraft the registry lists as Cessna 150H. 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
| 1968 | 3 |
|---|---|
| 1969 | 2 |
| 1970 | 3 |
| 1971 | 1 |
| 1975 | 2 |
| 1976 | 1 |
| 1979 | 2 |
| 1986 | 1 |
| 1998 | 1 |
| 2011 | 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 ('2071818'))
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 ('2071818'))
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 CEN11LA575Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Sabetha, KSThe pilot's failure to maintain adequate airspeed, which resulted in a stall. Contributing to the accident was the pilot's lack of certification to act as a pilot and his lack of recent experience.NTSB CHI98LA138Accident · No injuriesLimited investigationFinal reportCessna 150H · Benton, KSthe pilot's failure to assure an adequate fuel supply to complete the flight by refueling the airplane en route resulting in fuel exhaustion. A factor was the hedgerow which was contacted during the landing and the dark night conditions.NTSB MKC87FA002Accident · 2 fatalField investigationFinal reportCessna 150 · Fort Scott, KSThe purpose of the flt was to observe and photograph the effects of a flood which had inundated a part of the city of Fort Scott. The acft was observed flying low and slow over the city. Witnesses said the acft was flying from west to east and made a turn…NTSB MKC79FCQ38Accident · No injuriesClosedCessna 150H · Columbus, KSNTSB MKC79DCQ12Accident · No injuriesClosedCessna 150 · Kinsley, KSNTSB MKC76DCQ74Accident · No injuriesClosedCessna 150 · Clay Center, KSNTSB MKC75DCG45Accident · Minor injuriesClosedCessna 150 · Meriden, KSNTSB MKC75FCG33Accident · No injuriesClosedCessna 150 · Topeka, KSNTSB MKC71DCG65Accident · No injuriesClosedCessna 150H · Stillwell, KSNTSB MKC70DCG23Accident · No injuriesClosedCessna 150 · Gardner, KSNTSB MKC70DCQ18Accident · No injuriesClosedCessna 150H · Goodland, KSNTSB MKC70DCQ06Accident · No injuriesClosedCessna 150H · Augusta, KSNTSB MKC70D0107Accident · No injuriesClosedCessna 150 · Olathe, KSNTSB MKC69A0053Accident · 3 fatalClosedCessna 150H · Kansas City, KSNTSB MKC69D0233Accident · No injuriesClosedCessna 150 · Kansas City, KSNTSB MKC69D0234Accident · No injuriesClosedCessna 150 · Leavenworth, KSNTSB MKC69D0039Accident · Minor injuriesClosedCessna 150H · Oxford, KS