NTSB investigations: Cessna 150F, MS
15 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 | 1 |
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1999 | 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\" = 'MS' 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" = 'MS' 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 ATL00LA005Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Bay Springs, MSThe pilot's failure to maintain flying speed that resulted in a loss of control and stall. A factor was a stuck exhaust valve.NTSB MIA89LA171Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Picayune, MSInadequate preflight by the pilot and his miscalculation of fuel, which resulted in fuel starvation from lack of fuel; and the pilot's failure to see-and-avoid the power lines during the forced landing. The power lines were a contributing factor.NTSB MIA87LA053Accident · No injuriesLimited investigationFinal reportCessna 150F · Tunica, MSThe plt stated that during landing roll he lost control of the acft and it swerved off the right side of the rwy. The acft traveled into a plowed field and the nose gear collapsed.NTSB ATL85LA284Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Holly Springs, MSThe stu plt on his fourth solo flt elected to make a touch-and-go lng prior to going to the practice area. After turning base on the closed VFR traffic pattern, he states that he could not find the runway and allosed the airspeed to decrease too low. When he…NTSB ATL83FKQ01Accident · 2 fatalFinal reportCessna 150F · Sidon, MSThe student pilot and passenger departed jackson on a flight to madison, MS. The highway patrol received a report of a low flying aircraft and a loud noise in the vicinity of Sidon, MS, the aircraft wreckage was found the next morning in a soy bean field. The…NTSB ATL80FKQ01Accident · Serious injuriesClosedCessna 150 · Prentiss, MSNTSB MIA74FKQ12Accident · Minor injuriesClosedCessna 150F · Batesville, MSNTSB MIA73FKQ28Accident · No injuriesClosedCessna 150 · Wiggins, MSNTSB MIA71DKQ20Accident · No injuriesClosedCessna 150 · Edinburg, MSNTSB MIA70F0101Accident · No injuriesClosedCessna 150F · Louisville, MSNTSB MIA69D0154Accident · No injuriesClosedCessna 150F · Jackson, MSNTSB MIA68D0248Accident · No injuriesClosedCessna 150 · Mccomb, MSNTSB MIA67F0412Accident · Minor injuriesClosedCessna 150F · Wiggins, MSNTSB MIA67F0272Accident · No injuriesClosedCessna 150 · Icksburg, MSNTSB MIA66F0350Accident · No injuriesClosedCessna 150 · Waynesboro, MS