NTSB investigations, 1973, NE

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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

19622026
NTSB investigations, 1973, NE per year, 1962–2026: 1,895 cases
19621
196458
196567
196672
196789
196880
196988
197074
197193
197264
197352
197471
197547
197664
197752
197849
197941
198036
198134
198242
198339
198440
198531
198627
198721
198816
198922
199013
199124
199220
199321
199420
199516
199614
199714
199828
199923
200013
200119
200214
200312
200411
200515
200617
200711
200813
200915
201013
20117
201221
201311
201411
201511
201610
20179
201812
201913
20209
20219
202214
202310
202417
202511
20264

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\") = 1973
    AND c.\"eventStateOrRegion\" = 'NE' 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 MKC74DCJ22Accident · No injuriesClosedCessna 120 · Wilber, NEDec 31, 1973 · N2447N · Substantial damageNTSB MKC74DCJ21Accident · No injuriesClosedCessna 172 · Omaha, NEDec 29, 1973 · N8213B · Substantial damageNTSB MKC74DCJ23Accident · No injuriesClosedCessna 170A · Merriman, NEDec 27, 1973 · N1418D · Substantial damageNTSB MKC74DCJ20Accident · No injuriesClosedCessna 150 · Angora, NEDec 10, 1973 · N11183 · Substantial damageNTSB MKC74FCJ17Accident · No injuriesClosedCessna 172 · Beatrice, NEDec 2, 1973 · N2594L · DestroyedNTSB MKC74DCJ19Accident · No injuriesClosedBell 206A · North Platte, NEDec 2, 1973 · N7881S · Substantial damageNTSB MKC74FCJ18Accident · No injuriesClosedPiper PA-22 · Valparaiso, NEDec 1, 1973 · N3323A · Substantial damageNTSB MKC74AK023Accident · 1 fatalClosedTaylorcraft BC12-D · Fairbury, NENov 14, 1973 · N5041M · DestroyedNTSB MKC74DGJ15Accident · No injuriesClosedPiper PA-28 · Gordon, NEOct 28, 1973 · N55875 · Substantial damageNTSB MKC74DCJ16Accident · No injuriesClosedErco 415C · Trenton, NEOct 21, 1973 · N2605H · Substantial damageNTSB MKC74FCJ14Accident · No injuriesClosedAero Comdr 200D · Emerald, NEOct 20, 1973 · N2979T · Substantial damageNTSB MKC74FCJ13Accident · Minor injuriesClosedCessna 182M · Seward, NEOct 7, 1973 · N676KF · DestroyedNTSB MKC74DCJ11Accident · No injuriesClosedPiper PA-18 · Ainsworth, NESep 25, 1973 · N8519Y · Substantial damageNTSB MKC74AK012Accident · 3 fatalClosedGates Lear 25 · Lincoln, NESep 25, 1973 · N40LB · DestroyedNTSB MKC74DCJ10Accident · No injuriesClosedPiper PA-25 · Gresham, NESep 15, 1973 · N6481Z · Substantial damageNTSB MKC74FCJ09Accident · Minor injuriesClosedBeech 58 · Omaha, NESep 10, 1973 · N9041Q · Substantial damageNTSB MKC74FCJ08Accident · No injuriesClosedBeech C35 · Papillion, NEAug 28, 1973 · N5852C · Substantial damageNTSB MKC74FCJ07Accident · Serious injuriesClosedCessna 177A · Omaha, NEAug 25, 1973 · N30562 · DestroyedNTSB MKC74FCJ06Accident · No injuriesClosedPiper PA-25 · Thurston, NEAug 20, 1973 · N4844Y · Substantial damageNTSB MKC74FCJ04Accident · No injuriesClosedPiper PA-28 · Lincoln, NEAug 2, 1973 · N4406J · Substantial damageNTSB MKC74DCJ12Accident · No injuriesClosedPiper PA-25 · Bertrand, NEAug 2, 1973 · N6557Z · Substantial damageNTSB MKC74DCJ05Accident · No injuriesClosedCessna 150J · North Platte, NEAug 2, 1973 · N50576 · Substantial damageNTSB MKC74DCJ03Accident · No injuriesClosedPiper PA-28 · Ogallala, NEJul 22, 1973 · N2683T · Substantial damageNTSB MKC74DCJ02Accident · No injuriesClosedBeech P35 · Scottsbluff, NEJul 14, 1973 · N525KG · Substantial damageNTSB MKC74DCJ01Accident · No injuriesClosedPiper PA-25 · Lynch, NEJul 10, 1973 · N6520Z · Substantial damageNTSB MKC73DCJ50Accident · No injuriesClosedPiper PA-28 · Hay Springs, NEJun 28, 1973 · N5273S · DestroyedNTSB MKC73AK076Accident · 2 fatalClosedBeech D17S · Kimball, NEJun 25, 1973 · N60148 · DestroyedNTSB MKC73AK075Accident · 1 fatalClosedPiper PA-18 · Grant, NEJun 24, 1973 · N9459D · DestroyedNTSB MKC73FCJ49Accident · Minor injuriesClosedMooney M20A · Bassett, NEJun 23, 1973 · N8134E · Substantial damageNTSB MKC73FCJ48Accident · Minor injuriesClosedPiper PA-15 · Schwyler, NEJun 13, 1973 · N4403H · Substantial damageNTSB MKC73DCJ45Accident · No injuriesClosedPiper PA-25 · North Loup, NEJun 6, 1973 · N4519Y · Substantial damageNTSB MKC73DCJ47Accident · Minor injuriesClosedPiper PA-25 · Stamford, NEJun 5, 1973 · N7114Z · DestroyedNTSB MKC73DCJ46Accident · No injuriesClosedPiper PA-22 · Nebraska Cty, NEJun 3, 1973 · N8669D · Substantial damageNTSB MKC73DCJ44Accident · No injuriesClosedPiper J3C-65 · Lodgepole, NEJun 2, 1973 · N6786H · Substantial damageNTSB MKC73DCJ39Accident · Minor injuriesClosedGernr Evans WE-1 · Kimball, NEMay 31, 1973 · N5936 · Substantial damageNTSB MKC73DCJ43Accident · No injuriesClosedCessna 150 · Plattsmouth, NEMay 29, 1973 · N6503S · Substantial damageNTSB MKC73FCJ41Accident · 1 fatalClosedChampion 7GCBC · Lexington, NEMay 19, 1973 · N1802G · Substantial damageNTSB MKC73DCJ42Accident · No injuriesClosedLuscombe 8A · Sidney, NEMay 19, 1973 · N71847 · Substantial damageNTSB MKC73FCJ40Accident · 1 fatalClosedScorpion Single · Grand Island, NEMay 17, 1973 · N5406 · DestroyedNTSB MKC73DCJ38Accident · No injuriesClosedCessna 180H · Ponca, NEMay 10, 1973 · N9744G · Substantial damageNTSB MKC73DCJ37Accident · No injuriesClosedPiper PA-16 · Atkinson, NEMay 7, 1973 · N5241H · Substantial damageNTSB MKC73DCJ36Accident · No injuriesClosedPiper PA-18 · Ogallala, NEApr 29, 1973 · N13949 · Substantial damageNTSB MKC73FCJ35Accident · Serious injuriesClosedPiper PA-18 · Maywood, NEApr 28, 1973 · N1228A · DestroyedNTSB MKC73DCJ34Accident · No injuriesClosedCessna 188B · Sutton, NEApr 24, 1973 · N4463Q · Substantial damageNTSB MKC73FCJ33Accident · No injuriesClosedCessna 150L · Fort Calhoun, NEApr 4, 1973 · N16098 · Substantial damageNTSB MKC73DCJ32Accident · No injuriesClosedCessna T-50 · Omaha, NEMar 27, 1973 · N54302 · 2 aircraft · Minor damageNTSB MKC73FCJ31Accident · No injuriesClosedCessna 310G · Omaha, NEMar 6, 1973 · N2909R · Substantial damageNTSB MKC73FCJ30Accident · No injuriesClosedCessna 140A · Mc Cook, NEMar 1, 1973 · N5687C · Substantial damageNTSB MKC73FCJ29Accident · 1 fatalClosedCessna A188B · Hebron, NEFeb 22, 1973 · N4493Q · DestroyedNTSB MKC73DCJ28Accident · No injuriesClosedChampion 7GCAA · No.Platte, NEJan 22, 1973 · N8319V · Substantial damage