Skip to content

Fatal NTSB investigations: Cessna 150D

29 cases on aircraft the registry lists as Cessna 150D. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071810')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071810'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071810'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN11FA240Accident · 2 fatalField investigationFinal reportCessna 150D · Baraboo, WIThe student pilot’s inadequate preflight planning and his decision to continue the flight into instrument meteorological conditions, which resulted in a subsequent loss of airplane control.Mar 20, 2011 · N4178U · Substantial damage NTSB LAX94LA286Accident · 2 fatalLimited investigationFinal reportCessna 150D · Carrville, CAa loss of engine power for undetermined reasons. The mountainous terrain and lack of a suitable forced landing area within gliding distance was a factor in the accident.Jul 16, 1994 · N6052T · Destroyed NTSB ATL88FA198Accident · 1 fatalField investigationFinal reportCessna 150 · Eastman, GAThe accident occurred after takeoff from a private sod airstrip. A witness saw the aircraft climb to about 500 feet. It then started losing altitude, dropped out of sight, and crashed. The aircraft impacted the ground in a nose low attitude and burned.…Jun 22, 1988 · N4282U · Destroyed NTSB MKC87FA044Accident · 2 fatalField investigationFinal reportCessna 150D · Central City, NEAt about 0305 CST, witnesses in vehicles saw the acft lndg lgt as they were driving along a hwy. they rprtd the lgt was moving erratically as the acft was proceeding along the hwy at low alt. Subsequently, the acft struck a utility pole & power lines, then…Feb 1, 1987 · N4372U · Destroyed NTSB LAX86LA302Accident · 1 fatalLimited investigationFinal reportCessna 150D · San Diego, CAA Cessna 150D collided with the pacific ocean while spotting fish approximately 5 mi from the coast. The acft owner and operator indicated that the plt was FAA licensed and current. FAA records revealed the plt was issued a student plt certificated along with…Jul 23, 1986 · N5917T · Destroyed NTSB CHI84FA107Accident · 1 fatalField investigationFinal reportCessna 150D · Wanatah, INAt about 1716 CST, the non-instrument rated plt contacted a fss, reported he was in the clouds with about 1 hr of fuel on board & requested 'vector me someplace.' He was told that indianapolis was VFR, but the plt stated that he could not reach indianapolis &…Feb 11, 1984 · N4361U · Substantial damage NTSB SEA83FA178Accident · 1 fatalField investigationFinal reportCessna 150 · Granite Falls, WAThe acft collided with the ground in a vertical nose down attitude. The engine was imbedded 4 ft into the ground. All components of the acft were accounted for in the immediate area of the impact. Witnesses observed the acft in a left turn before falling into…Aug 14, 1983 · N4446U · Destroyed NTSB MKC80FA005Accident · 1 fatalClosedCessna 150D · Stet, MONov 16, 1979 · N7999Z · Destroyed NTSB FTW74AF031Accident · 2 fatalClosedCessna 150D · Melville, LANov 17, 1973 · N4113U · Destroyed NTSB FTW73AF072Accident · 1 fatalClosedCessna 150D · Monahans, TXJun 7, 1973 · N4192U · Destroyed NTSB OAK73AP013Accident · 1 fatalClosedCessna 150D · Auburn, CANov 26, 1972 · N4107U · Destroyed NTSB MKC73AK038Accident · 1 fatalClosedCessna 150D · Wellman, IANov 9, 1972 · N5913T · Destroyed NTSB LAX71AL009Accident · 2 fatalClosedCessna 150 · Wrightwood, CASep 6, 1970 · N4412U · Destroyed NTSB MKC71AK010Accident · 2 fatalClosedCessna 150D · Osage, IAAug 27, 1970 · N5933T · 2 aircraft · Destroyed NTSB FTW70A0035Accident · 1 fatalClosedCessna 150 · Marianna, ARNov 25, 1969 · N4581U · Destroyed NTSB DEN70A0032Accident · 2 fatalClosedCessna 150D · Denver, CONov 4, 1969 · N6068T · 2 aircraft · Destroyed NTSB DIA69A0038Accident · 1 fatalClosedCessna 150D · Martinsburg, WVFeb 1, 1969 · N5900T · Destroyed NTSB DEN69A0002Accident · 2 fatalClosedCessna 150 · Bailey, COJul 28, 1968 · N4416U · Destroyed NTSB SEA68A0046Accident · 2 fatalClosedCessna 150D · Renton, WAJan 11, 1968 · N4444U · Destroyed NTSB MKC68A0039Accident · 1 fatalClosedCessna 150D · Hillsboro, KSDec 24, 1967 · N4227U · Destroyed NTSB LAX67A0096Accident · 1 fatalClosedCessna 150 · Newhall, CAApr 15, 1967 · N4181U · Destroyed NTSB MIA66D0419Accident · 1 fatalClosedCessna 150 · Marathon, FLNov 28, 1965 · N4318U · Substantial damage NTSB CHI66A0025Accident · 1 fatalClosedDouglas DC3 · Louisville, KYSep 10, 1965 · N272R · 2 aircraft · Substantial damage NTSB FTW66A0021Accident · 1 fatalClosedCessna 150D · Leander, TXAug 21, 1965 · N5970T · Destroyed NTSB OAK66A0005Accident · 1 fatalClosedCessna 150 · Stockton, CAAug 8, 1965 · N4351U · Destroyed NTSB UNK65X0809Accident · 3 fatalClosedCessna 150D · Pomona, CANov 23, 1964 · N4359U · 2 aircraft · Destroyed NTSB UNK65X0743Accident · 2 fatalClosedCessna 150 · Cincinnati, OHNov 16, 1964 · N4350U · Destroyed NTSB UNK65X0412Accident · 2 fatalClosedCessna 150 · Crestview, FLOct 24, 1964 · N6067T · Destroyed NTSB UNK64X1426Accident · 1 fatalClosedCessna 150 · Alta Loma, CAApr 23, 1964 · N615CF · Destroyed