NTSB investigations: Cessna 150F
30 cases on aircraft the registry lists as Cessna 150F, where the first occurrence was “In flight collision with object”. 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 |
|---|---|
| 1983 | 2 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 6 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 1 |
| 1995 | 1 |
| 1997 | 2 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 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 ('2071814')
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\" = 220))
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 ('2071814')
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" = 220))
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 CHI04LA254Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Ancona, ILThe pilot became incapacitated (unconscious) for undetermined reasons which resulted in his inability to maintain altitude.NTSB IAD02LA068Accident · No injuriesLimited investigationFinal reportCessna 150 · Griswold, CTthe pilot's improper pre-flight planning and decision to depart a field with insufficient runway. Factors were the rough/uneven terrain, high obstructions and the tailwind.NTSB ATL01LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Lake City, FLThe pilots failure to maintain clearance during an approach to land, that resulted in an in-flight collision with trees.NTSB ATL00LA007Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Arecibo, PRThe pilot's failure to maintain altitude clearance during final approach to landing. A factor was the hay bundles.NTSB FTW98LA048Accident · No injuriesLimited investigationFinal reportCessna 150F · Brigham City, UTfailure of the pilot to maintain lateral (or vertical) clearance from a tree, during takeoff. Related factors were: the tree, and the pilot's improper use of flaps.NTSB ATL97LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Kenly, NCThe pilot's failure to see and avoid a utility line on final approach to land. The sunglare and utility line were factors.NTSB CHI95LA077Accident · No injuriesLimited investigationFinal reportCessna 150F · Castlewood, SDthe pilot's inadequate preflight planning and preparation. Factors associated with the accident are the snow covered/drifted runway, and a fence.NTSB NYC92FA185Accident · 1 fatalField investigationFinal reportCessna 150F · Lake Neepaulin, NJAn inflight collision with trees after the pilot failed to outclimb the terrain. Factors related to the accident were the pilot's improper use of the flaps and the pilot's decision to operate the airplane over the maximum allowable gross weight.NTSB ATL91LA103Accident · No injuriesLimited investigationFinal reportCessna 150F · Monroe, NCThe pilot's selection of unsuitable terrain for takeoff. The unmowed grass runnway was a related factor.NTSB CHI91LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Mccook, NEA poorly planned approach and inadequate visual lookout by the pilot.NTSB LAX90LA192Accident · No injuriesLimited investigationFinal reportCessna 150F · Franklin, CAThe fixed base operator mechanic used improper bolt/nut during repair of the elevator system.NTSB BFO90FA025Accident · 1 fatalField investigationFinal reportCessna 150F · Arden, NCThe pilot failure to maintain adequate altitude and clearance from a powerline during the landing approach. A factor was the unmarked powerline.NTSB ATL89LA155Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Trinity, NCThe pilots failure to select a suitable takeoff area based on the weight of the aircraft and the atmospheric conditions at the time of takeoff.NTSB ATL89LA137Accident · No injuriesLimited investigationFinal reportCessna 150F · Jacksonville, NCThe pilot's failure to properly preflight and plan which resulted in a collision with trees. The pilot attempted a takeoff with an over gross weight condition.NTSB LAX89LA053Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Santa Maria, CADuring a pleasure flight, the airplane was being flown along a ridgeline while the pilot and passenger were looking for an old airplane wreck. The pilot was distracted and did not notice the airplane was entering a canyon and rising terrain. When the pilots…NTSB NYC88LA240Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Burlington, CTThe plt was attempting to land at the mountain arpt. Patwas indicated the winds were from the north at 15 KTS. Gusts were not reported. The plt made her apch at 70 mph IAS and with 20 deg of flaps deployed. As she flared the acft, she encountered a gust of…NTSB LAX88LA217Accident · 1 fatalLimited investigationFinal reportCessna 150F · Quartzsite, AZNTSB BFO88FA051Accident · 2 fatalField investigationFinal reportCessna 150F · Petersburg, VAThe plt was being accompanied by a 182 during the flt from NC to tangier island. Both acft landed at Petersburg. A passenger in the 182 had become ill. After refueling and spending a short time at Petersburg, both acft departed for tangier island with the…NTSB ATL88LA187Accident · No injuriesLimited investigationFinal reportCessna 150F · Mc Kenzie, ALThe plt reported that he attempted to takeoff from a pasture that was 'too short'. The airplane began to settle shortly after t/o and one of the MLG wheels struck a short post in the pasture. The airplane hdg was altered and the airplane crashed into a fence.…NTSB MKC88FA086Accident · 1 fatalField investigationFinal reportCessna 150F · Mansfield, MOA witness saw the acft flying at low alt as it passed in front of her car at dusk in a northeasterly drctn. She rprtd the acft contd down a valley toward power lines that spanned an open field. She saw the acft pull up rapidly, become entangled in the power…NTSB LAX88LA036Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Carmel Valley, CAThe plt & passenger were on a flt to an arpt with a 2475' rwy & a displaced threshold of 665'. The plt rprtd that when he entered the apch to lnd on rwy 11, the acft was higher than necessary. He contd the apch, but when the acft had not touched down, after…NTSB NYC87LA196Accident · No injuriesLimited investigationFinal reportCessna 150F · Roseville, PAWitnesses rprtd the acft flew over a pvt strip at low alt, then it began climbing over rising, wooded terrain. Subsequently, the acft would not outclimb the terrain & it crashed into the treetops. No preimpact mechanical problem was found.NTSB ATL87FA052Accident · 2 fatalField investigationFinal reportCessna 150F · Newville, ALThe aircraft was observed flying at low levels during an orientation/pleasure flight for a friend's out-of-town relative visiting over the holidays. The professional military pilot had been checked out in the civilian Cessna 150 six weeks prior to the…NTSB FTW86LA172Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Sulphur, OKThe acft struck a large bird at 2,500 ft MSL in cruise flt, which took out the windshield. The plt determined that he could not sustain level flt due to the increased drag and loss of lift and elected to execute an emergency landing in a pasture. During the…NTSB CHI86LA209Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Milford, MIThe pilot used full power and 10 degrees of flaps to perform a short field takeoff from a sod strip. He rotated for takeoff less than halfway down the 1100 ft runway, then kept the acft low to accelerate to 80 KTS. He then pulled up to clear a row of 40 ft…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 MKC85FA069Accident · 1 fatalField investigationFinal reportCessna 150F · Waldron, MOWhile maneuvering northbound on the Missouri river levee the passenger noticed the plt flying just above the levee road. The passenger stated the plt told him they were forty feet off the ground but sometimes lower. The passenger stated he saw the pickup…NTSB SEA83FA186Accident · Serious injuriesField investigationFinal reportCessna 150F · Bellingham, WAThe plt & passenger departed on a local sight-seeing flt. While flying low over the narrow part of lake samish, the acftcollided with a power line, then crashed in the water. The power lines were 129 ft above the water at the lowest point.NTSB SEA83LA076Accident · No injuriesLimited investigationFinal reportCessna 150F · Anacortes, WAThe uncertificated plt had made several attempts to land when he struck a tree in the approach path with the right wing. The acft then left the area for a short period of time, returned & made what was described as a bumpy landing. The acft use was…NTSB LAX82FXQ07Accident · 1 fatalFinal reportCessna 150 · Wadsworth, NVWhile flying over the truckee river on a local flight, the left wing of the aircraft struck a group of five powerlines. The aircraft then impacted the water in a nose down attitude. It was carried downstream about 100 yards by the current before coming to…