Skip to content

NTSB investigations, 1979

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

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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 year(c."eventDate") = 1979 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 year(c.\"eventDate\") = 1979
  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 year(c."eventDate") = 1979
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 SEA80DYP03Accident · No injuriesClosedBellanca 7KCAB · College Place, WANov 11, 1979 · N2680Z · Substantial damage NTSB MIA80FKT13Accident · No injuriesClosedBeech 58 · Miami, FLNov 11, 1979 · N98SC · Substantial damage NTSB MIA80AA011Incident · No injuriesClosedDouglas DC-10 · Luxemburg, GeorgiaNov 11, 1979 · XA-DUH · Minor damage NTSB LAX80FVW04Accident · No injuriesClosedCessna 150 · Las Vegas, NVNov 11, 1979 · N3352V · Substantial damage NTSB LAX80FUQ03Accident · 2 fatalClosedRand KR-2 · Mojave, CANov 11, 1979 · N56WP · Destroyed NTSB LAX80DVD01Accident · No injuriesClosedCessna 152 · Santa Rosa, CANov 11, 1979 · N67708 · Substantial damage NTSB FTW80FRG08Accident · Minor injuriesClosedPiper PA-28R · Jonestown, TXNov 11, 1979 · N6239C · Destroyed NTSB FTW80FPA02Accident · No injuriesClosedBellanca 17-30A · Dallas, TXNov 11, 1979 · N8270R · Destroyed NTSB FTW80FA011Accident · 2 fatalClosedCessna 172M · Sugarland, TXNov 11, 1979 · N21479 · Destroyed NTSB CHI80FEX02Accident · Serious injuriesClosedCessna 206 · Noblesville, INNov 11, 1979 · N756LA · Destroyed NTSB CHI80FEP05Accident · Serious injuriesClosedCessna 150M · Omro, WINov 11, 1979 · N45718 · Substantial damage NTSB MKC80DCG01Accident · Minor injuriesClosedCessna 152 · Warrensburg, MONov 10, 1979 · N69206 · Substantial damage NTSB MIA80DLD09Accident · No injuriesClosedHughes 269B · Winter Haven, FLNov 10, 1979 · N9393F · Substantial damage NTSB MIA80DKG09Accident · No injuriesClosedPiper PA-38 · Statesboro, GANov 10, 1979 · N2317B · Substantial damage NTSB LAX80FA012Accident · 2 fatalClosedPiper PA-28 · Phoenix, AZNov 10, 1979 · N6350W · Destroyed NTSB LAX80DUM04Accident · Minor injuriesClosedSchweizer SGS135 · San Diego, CANov 10, 1979 · N40BS · Substantial damage NTSB FTW80IA010Incident · No injuriesClosedDouglas DC-3C · Grand Prairie, TXNov 10, 1979 · N103CA · Minor damage NTSB DEN80DQA10Accident · No injuriesClosedPiper PA-23 · Ruidoso, NMNov 10, 1979 · N5998Y · Minor damage NTSB SEA80FYE07Accident · Minor injuriesClosedMaule M-5 · Maple Valley, WANov 9, 1979 · N376X · Destroyed NTSB MKC80DER10Accident · No injuriesClosedCessna 421A · Crystal, MNNov 9, 1979 · N4025L · Substantial damage NTSB MIA80DLD08Accident · No injuriesClosedCessna 152 · Cedar Key, FLNov 9, 1979 · N24308 · Substantial damage NTSB LAX80FVW03Accident · No injuriesClosedCessna 150M · Las Vegas, NVNov 9, 1979 · N4014V · Destroyed NTSB LAX80FUJ09Accident · No injuriesClosedCessna P210N · Phoenix, AZNov 9, 1979 · N6287P · Substantial damage NTSB LAX80DXQ18Accident · No injuriesClosedBeech 35-33 · Elko, NVNov 9, 1979 · N661V · Substantial damage NTSB LAX80DVG04Accident · No injuriesClosedCessna 150 · Anqwin, CANov 9, 1979 · N1758Q · Substantial damage NTSB LAX80DUJ21Accident · No injuriesClosedPiper PA-28 · Prescott, AZNov 9, 1979 · N47749 · Substantial damage NTSB LAX79FVM07Accident · No injuriesClosedAmer Avco AA-5 · San Jose, CANov 9, 1979 · N5457L · Substantial damage NTSB IAD80DID02Accident · No injuriesClosedCessna T-41 · Richmond, VANov 9, 1979 · N31FL · Substantial damage NTSB IAD80DID01Accident · No injuriesClosedGrum Amer AA1-C · Cheasapeake, VANov 9, 1979 · N9552U · Substantial damage NTSB DEN80DQD02Accident · Minor injuriesClosedCessna 182N · Hacienda Sr Ln, NMNov 9, 1979 · N9128G · Substantial damage NTSB CHI80FEG03Accident · No injuriesClosedCessna 182 · West Milton, OHNov 9, 1979 · N1907X · Substantial damage NTSB LAX80FVM06Accident · 1 fatalClosedBoeing A75N1 · Paicines, CANov 8, 1979 · N686W · Destroyed NTSB LAX80DXQ04Accident · No injuriesClosedCessna 150M · Reno, NVNov 8, 1979 · N9414U · Substantial damage NTSB IAD80FIA02Accident · No injuriesClosedBeech 95-55 · Washington, DCNov 8, 1979 · N77PW · Substantial damage NTSB FTW80FPM04Accident · Minor injuriesClosedNavion B · Smithville, OKNov 8, 1979 · N4860K · Substantial damage NTSB SEA80FYM04Accident · No injuriesClosedBell 206A · Amity, ORNov 7, 1979 · N6212N · Substantial damage NTSB SEA80DYE06Accident · No injuriesClosedAero Comdr 112A · Vashon Island, WANov 7, 1979 · N1478J · Substantial damage NTSB NYC80FGM06Accident · No injuriesClosedCessna C152 · Belle Vernon, PANov 7, 1979 · N757RA · Substantial damage NTSB NYC80FA009Accident · No injuriesClosedPiper PA-31 · Stamford, CTNov 7, 1979 · N405CA · 2 aircraft · Substantial damage NTSB MKC80DER09Accident · No injuriesClosedCessna 340A · Grand Rapids, MNNov 7, 1979 · N1389G · Substantial damage NTSB LAX80DXQ02Accident · No injuriesClosedAerospatile 315B · Nells, NVNov 7, 1979 · N3593Z · Substantial damage NTSB FTW80DPD06Accident · No injuriesClosedCessna 182 · Roanoke, TXNov 7, 1979 · N2309G · Substantial damage NTSB FTW80DPD04Accident · Minor injuriesClosedCessna 172 · Wichita Falls, TXNov 7, 1979 · N737HE · Substantial damage NTSB CHI80DEM05Accident · No injuriesClosedCessna 150D · Niron Mountain, MINov 7, 1979 · CG-CDR · Substantial damage NTSB NYC80FHD07Accident · No injuriesClosedHiller UH12B · Mount Holly, NJNov 6, 1979 · N10195 · Substantial damage NTSB NYC80DHD06Accident · No injuriesClosedStinson 108-2 · Toms River, NJNov 6, 1979 · N97247 · Substantial damage NTSB LAX80DUJ11Accident · No injuriesClosedRyan ST-A · Phoenix, AZNov 6, 1979 · N14985 · Substantial damage NTSB IAD80DKW02Accident · No injuriesClosedCallair A-9 · Greeneville, TNNov 6, 1979 · N8267H · Substantial damage NTSB FTW80FPG02Accident · Serious injuriesClosedPiper J-3 · Pine Bluff, ARNov 6, 1979 · N98667 · Destroyed NTSB CHI80FEI06Accident · Minor injuriesClosedCessna 205 · Mansfield, OHNov 6, 1979 · N8173Z · Substantial damage