NTSB investigations: Cessna 150F, 1974

50 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

19652026
NTSB investigations: Cessna 150F, 1974 per year, 1965–2026: 1,647 cases
196534
1966229
1967264
1968172
1969124
197081
197168
197262
197349
197450
197538
197628
197718
197826
197924
198021
198120
19829
19836
198415
198512
198615
198714
198825
19898
199015
19916
199214
19937
19946
19958
199614
199713
199811
199911
20008
20014
20028
20038
20044
20058
20064
20072
20085
20093
20103
20115
20127
20131
20142
20157
20167
20174
20185
20196
20201
20214
20225
20235
20245
20258
20261

Latest 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 year(c.\"eventDate\") = 1974
    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.

NTSB MKC75FCD30Accident · No injuriesClosedCessna 150 · Ottuma, IADec 31, 1974 · N7757F · Substantial damageNTSB CHI75DEE35Accident · No injuriesClosedCessna 150 · Richton Park, ILDec 23, 1974 · N7137F · Substantial damageNTSB MKC75FCA17Accident · No injuriesClosedCessna 150F · Morley, MODec 13, 1974 · N8621G · Substantial damageNTSB LAX75FUG21Accident · No injuriesClosedCessna 150F · Ontario, CADec 5, 1974 · N3524L · Substantial damageNTSB NYC75FFA23Accident · Minor injuriesClosedCessna 150 · Highland, NYDec 1, 1974 · N7910F · Substantial damageNTSB OAK75DVG37Accident · No injuriesClosedCessna 150 · Pope Valley, CANov 29, 1974 · N8956S · Substantial damageNTSB LAX75FNG20Accident · No injuriesClosedCessna 150F · La Verne, CANov 25, 1974 · N8099S · Substantial damageNTSB IAD75FLJ14Accident · Minor injuriesClosedCessna 150 · Wilmington, NCNov 25, 1974 · N8489G · Substantial damageNTSB MKC75DCG20Accident · No injuriesClosedCessna 150 · Olathe, KSNov 24, 1974 · N6420F · Substantial damageNTSB LAX75AL026Accident · 1 fatalClosedCessna 150F · Santa Maria, CANov 13, 1974 · N3026X · DestroyedNTSB DEN75FTE33Accident · Serious injuriesClosedCessna 150F · Durango, COOct 28, 1974 · N6435F · DestroyedNTSB MIA75DLG16Accident · No injuriesClosedCessna 150 · Anderson, SCOct 26, 1974 · N8668G · Substantial damageNTSB FTW75FRG29Accident · Minor injuriesClosedCessna 150F · Mathis, TXOct 20, 1974 · N8898S · Substantial damageNTSB CHI75FEV07Accident · No injuriesClosedCessna 150 · Galatia, ILOct 15, 1974 · N3088X · Substantial damageNTSB FTW75DPD12Accident · No injuriesClosedCessna 150 · Goldthwaite, TXOct 6, 1974 · N3506L · Substantial damageNTSB FTW75DRJ13Accident · No injuriesClosedCessna 150F · Nacogdoches, TXSep 17, 1974 · N3028X · Substantial damageNTSB SEA75DYE13Accident · Serious injuriesClosedCessna 150 · Lynden, WAAug 24, 1974 · N8671S · DestroyedNTSB SEA75AS010Accident · Serious injuriesClosedCessna 150 · Vancouver, WAAug 24, 1974 · N1445Q · 2 aircraft · DestroyedNTSB OAK75AP008Accident · 2 fatalClosedCessna 150 · Bear Valley, CAAug 17, 1974 · N3010X · DestroyedNTSB MKC75AK008Accident · Minor injuriesClosedCessna 150 · Aurora, NEAug 1, 1974 · N8154F · 2 aircraft · Minor damageNTSB CHI75DET04Accident · No injuriesClosedCessna 150 · Hobart, INJul 31, 1974 · N6466F · Substantial damageNTSB FTW75FPA05Accident · No injuriesClosedCessna 150 · Addison, TXJul 30, 1974 · N8786S · Substantial damageNTSB IAD75FHD18Accident · No injuriesClosedCessna 150 · Laurel, DEJul 28, 1974 · N7172F · Substantial damageNTSB FTW75FPD02Accident · No injuriesClosedCessna 150F · Springtown, TXJul 25, 1974 · N8653S · Substantial damageNTSB SEA75DYG04Accident · No injuriesClosedCessna 150 · Selah, WAJul 20, 1974 · N6822F · DestroyedNTSB SEA75FYE03Accident · Minor injuriesClosedCessna 150F · Buckley, WAJul 16, 1974 · N7777F · DestroyedNTSB NYC75FHD01Accident · No injuriesClosedCessna 150 · Philadelphia, PAJul 6, 1974 · N6953F · Substantial damageNTSB OAK74FVW24Accident · Minor injuriesClosedCessna 150F · Henderson, NVJun 22, 1974 · N7119F · Substantial damageNTSB FTW74DQG66Accident · No injuriesClosedCessna 150F · Snyder, TXJun 6, 1974 · N8208S · Substantial damageNTSB NYC74FHM31Accident · Serious injuriesClosedCessna 150 · Colts Neck, NJMay 25, 1974 · N3127X · Substantial damageNTSB LAX74DUM36Accident · No injuriesClosedCessna 150 · Oceanside, CAMay 24, 1974 · N8861S · Substantial damageNTSB FTW74ORG87Accident · No injuriesClosedCessna 150 · San Carlos, MexicoMay 24, 1974 · N7131C · Substantial damageNTSB NYC74FNE23Accident · Serious injuriesClosedCessna 150F · Monterey, MAMay 12, 1974 · N8234F · DestroyedNTSB LAX74AL073Accident · 2 fatalClosedCessna 150F · Chandler, AZMay 12, 1974 · N3112X · DestroyedNTSB FTW74FRA38Accident · Minor injuriesClosedCessna 150F · Orangefield, TXApr 28, 1974 · N8564G · Substantial damageNTSB LAX74AL074Accident · 2 fatalClosedCessna 150F · Johnsondale, CAApr 25, 1974 · N7173F · DestroyedNTSB OAK74DVA53Accident · No injuriesClosedCessna 150 · Coalinga, CAApr 6, 1974 · N8129F · Substantial damageNTSB CHI74AC079Accident · 1 fatalClosedCessna 150F · Glen Flora, WIMar 28, 1974 · N8654G · DestroyedNTSB OAK74DVM22Accident · No injuriesClosedCessna 150F · Salinas, CAMar 26, 1974 · N8604G · Substantial damageNTSB MIA74FKQ12Accident · Minor injuriesClosedCessna 150F · Batesville, MSMar 7, 1974 · N3538L · Substantial damageNTSB LAX74DUJ43Accident · No injuriesClosedCessna 150 · Roosevelt, AZFeb 18, 1974 · N6755F · DestroyedNTSB CHI74FEG16Accident · No injuriesClosedCessna 150 · Gallipolis, OHFeb 11, 1974 · N8636G · Substantial damageNTSB FTW74AF059Accident · 1 fatalClosedCessna 150F · Orange, TXJan 31, 1974 · N6545F · DestroyedNTSB DEN74DTE48Accident · No injuriesClosedCessna 172 · Ft Collins, COJan 30, 1974 · N7959F · Substantial damageNTSB MIA74DLG22Accident · No injuriesClosedCessna 150 · N Myrtle Bch, SCJan 27, 1974 · N6551F · Substantial damageNTSB IAD74DIJ10Accident · No injuriesClosedCessna 150F · Minerl Wells, WVJan 27, 1974 · N8048S · Substantial damageNTSB IAD74FID27Accident · No injuriesClosedCessna 150F · Gloucester, VAJan 16, 1974 · N8740G · Substantial damageNTSB FTW74FQG39Accident · No injuriesClosedCessna 150F · Amarillo, TXJan 14, 1974 · N222DF · Substantial damageNTSB CHI74FEG13Accident · No injuriesClosedCessna 150F · Phillipsburg, OHJan 8, 1974 · N7879F · Substantial damageNTSB CHI74AC055Accident · 1 fatalClosedCessna 150F · Marshall, MIJan 1, 1974 · N8204S · Destroyed