NTSB investigations, 1974, NV

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19632026
NTSB investigations, 1974, NV per year, 1963–2026: 2,360 cases
19631
196471
196556
196679
196777
196845
196951
197068
197166
197255
197346
197472
197555
197664
197755
197859
197951
198049
198146
198239
198338
198436
198540
198635
198726
198828
198936
199027
199133
199232
199329
199442
199522
199623
199725
199830
199942
200045
200137
200234
200329
200429
200525
200627
200738
200825
200928
201024
201122
201224
201328
201422
201521
201631
201731
201827
201929
202022
202119
202222
202323
202416
202521
202612

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.\"eventStateOrRegion\" = 'NV' AND c.\"eventCountry\" = 'USA'
  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 OAK75FVW11Accident · No injuriesClosedMooney M20C · Las Vegas, NVDec 21, 1974 · N6563U · Substantial damageNTSB OAK75DXQ33Accident · No injuriesClosedCessna 182 · Jackpot, NVDec 19, 1974 · N7211N · Substantial damageNTSB OAK75AP024Accident · Serious injuriesClosedCessna 180C · Lovelock, NVDec 14, 1974 · N3333D · DestroyedNTSB OAK75AP023Accident · Serious injuriesClosedCessna 210T · Reno, NVDec 12, 1974 · N30374 · Substantial damageNTSB OAK75FVW10Accident · No injuriesClosedPiper PA-28R · Las Vegas, NVNov 27, 1974 · N41998 · Substantial damageNTSB OAK75AP033Accident · 1 fatalClosedPiper PA-28R · Las Vegas, NVNov 15, 1974 · N55245 · DestroyedNTSB OAK75FXQ30Accident · No injuriesClosedPiper PA-28 · Carson City, NVNov 1, 1974 · N55527 · Substantial damageNTSB OAK75FVW08Accident · No injuriesClosedCessna 205 · Sloan, NVOct 22, 1974 · N8281Z · Substantial damageNTSB OAK75FVW07Accident · Minor injuriesClosedCessna 150K · Las Vegas, NVOct 18, 1974 · N6279G · Substantial damageNTSB OAK75DXQ28Accident · No injuriesClosedAmer Avco AA1-B · Elko, NVOct 16, 1974 · N6289L · Substantial damageNTSB OAK75FXQ27Accident · No injuriesClosedCessna 206 · Reno, NVSep 26, 1974 · N2127F · Substantial damageNTSB OAK75DXQ25Accident · No injuriesClosedMaule M4220C · Reno, NVSep 15, 1974 · N40307 · Substantial damageNTSB OAK75FVW06Accident · No injuriesClosedCessna 172L · Las Vegas, NVSep 14, 1974 · N7286Q · Substantial damageNTSB OAK75FX022Accident · 1 fatalClosedBensen B-8M · Reno, NVSep 7, 1974 · N8183 · DestroyedNTSB OAK75FVW05Accident · No injuriesClosedBeech F50 · Las Vegas, NVSep 5, 1974 · N678T · Substantial damageNTSB OAK75FP010Accident · 4 fatalClosedPiper PA-28 · Reno, NVSep 2, 1974 · N6537W · DestroyedNTSB OAK75DXQ26Accident · No injuriesClosedPiper PA-28 · Oasis, NVAug 30, 1974 · N41971 · Substantial damageNTSB OAK75DXQ20Accident · No injuriesClosedBeech C35 · Elko, NVAug 21, 1974 · N636D · Substantial damageNTSB OAK75DXQ18Accident · No injuriesClosedAmer Avco AA-5 · Elko, NVAug 21, 1974 · N9520L · Substantial damageNTSB OAK75FXQ15Accident · No injuriesClosedBeech E35 · Reno, NVAug 16, 1974 · N3548B · Substantial damageNTSB OAK75DXQ21Incident · No injuriesClosedPiper PA-28 · Carson City, NVAug 15, 1974 · N1484T · Minor damageNTSB OAK75FVW02Accident · No injuriesClosedBeech B19 · N.Las Vegas, NVAug 14, 1974 · N24626 · Substantial damageNTSB OAK75FXQ12Accident · No injuriesClosedCessna 185 · Reno, NVAug 13, 1974 · N4030Y · Substantial damageNTSB OAK75FXQ09Accident · No injuriesClosedPiper PA-36 · Winnemucca, NVAug 2, 1974 · N40915 · Substantial damageNTSB OAK75DXQ07Accident · No injuriesClosedPiper PA-23 · Pyramid, NVJul 30, 1974 · N4694P · Substantial damageNTSB OAK75DVW01Accident · No injuriesClosedCessna 172 · Round Mt, NVJul 29, 1974 · N3641S · DestroyedNTSB OAK75FXQ06Accident · No injuriesClosedPiper PA-28 · Carson City, NVJul 28, 1974 · N7316J · Substantial damageNTSB OAK75DXQ11Accident · No injuriesClosedSnow 600S2D · Orovada, NVJul 28, 1974 · N1725S · Substantial damageNTSB OAK75DXQ13Accident · No injuriesClosedCessna 175 · Winnemucca, NVJul 21, 1974 · N7096M · Substantial damageNTSB OAK75AP003Accident · 1 fatalClosedCessna 206 · Lathrop Wells, NVJul 20, 1974 · N5218U · Substantial damageNTSB OAK75FXQ10Accident · Minor injuriesClosedCessna 150 · Empire, NVJul 17, 1974 · N6280T · DestroyedNTSB OAK75FXQ05Accident · Minor injuriesClosedPiper PA-25 · Wellington, NVJul 17, 1974 · N4343Y · Substantial damageNTSB OAK75DXQ02Accident · No injuriesClosedPiper PA-25 · Fallon, NVJul 13, 1974 · N6301Z · Substantial damageNTSB OAK75FXQ01Accident · 1 fatalClosedBell 206B · Reno, NVJul 5, 1974 · N206DB · DestroyedNTSB OAK74FVW24Accident · Minor injuriesClosedCessna 150F · Henderson, NVJun 22, 1974 · N7119F · Substantial damageNTSB OAK74DXQ44Accident · No injuriesClosedAeronca 7AC · Elko, NVJun 17, 1974 · N82269 · Substantial damageNTSB OAK74FVW23Accident · No injuriesClosedCessna 180 · Las Vegas, NVJun 14, 1974 · N9194C · Substantial damageNTSB OAK74DXQ43Accident · No injuriesClosedCessna 172 · Minden, NVJun 7, 1974 · N5139A · Substantial damageNTSB OAK74FVW22Accident · Minor injuriesClosedCessna 175 · Las Vegas, NVJun 3, 1974 · N7246M · DestroyedNTSB OAK74FXQ42Accident · No injuriesClosedCessna 411 · Reno, NVJun 1, 1974 · N4930T · Substantial damageNTSB OAK74DVW21Accident · No injuriesClosedHughes 269B · Las Vegas, NVMay 27, 1974 · N9542F · Substantial damageNTSB OAK74FXQ38Accident · No injuriesClosedGrumman G-164 · Fallon, NVMay 14, 1974 · N6538 · Substantial damageNTSB OAK74DXQ39Accident · No injuriesClosedCessna 150 · Reno, NVMay 14, 1974 · N50512 · Substantial damageNTSB OAK74FVW20Accident · Minor injuriesClosedHughes 269C · Las Vegas, NVMay 13, 1974 · N9631F · Substantial damageNTSB OAK74DXQ37Accident · No injuriesClosedSchweizer SGS232 · Yerrington, NVApr 27, 1974 · N17892 · Substantial damageNTSB OAK74FXQ34Accident · Minor injuriesClosedAlouette III · East Dayton, NVApr 24, 1974 · N8259 · Substantial damageNTSB OAK74FVW18Accident · No injuriesClosedPiper PA-16 · Sloan, NVApr 16, 1974 · N5916H · Substantial damageNTSB OAK74DXQ32Accident · No injuriesClosedPiper PA-28 · Reno, NVApr 14, 1974 · N9117J · DestroyedNTSB OAK74FVW19Accident · No injuriesClosedMooney M20E · Las Vegas, NVApr 13, 1974 · N6017Q · Substantial damageNTSB OAK74DXQ31Accident · No injuriesClosedPiper PA-23 · Ely, NVApr 12, 1974 · N1038P · Substantial damage