OpenAirDocs.org

NTSB investigations

1,978 cases where the phase of flight was Unknown.

Cases, newest first

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 990)
  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 FTW84LAMS1Accident · 1 fatalFinal reportPiper PA-34-200 · Gulf Of MexicoThe acft disappeared on a flt over a part of the Gulf Of Mexico south of corpus christi in an area of thunderstorm activity. The storms were densely packed and it was considered unlikely that VFR flt could be conducted in the area. Theaccident acft was in…Oct 9, 1983 · N4437T · DestroyedNTSB MIA84LA007Accident · 3 fatalLimited investigationFinal reportCessna T-210-J · FLThis acft is missing on a flt from andros town, Bahamas to ft. pierce, FL. After departure the acft contacted nassau to file a VFR clearance and called miami fss to report 60 DME east of ft. lauderdale in heavy rain. The plt requested information on how to…Oct 4, 1983 · N2284R · DestroyedNTSB NYC83FA254Accident · 3 fatalField investigationFinal reportBellanca 17-31ATC · Provincetown, MAThe acft crashed in cape cod bay during a night x-country flt. Two sections of wooden wing identified as from the same make and model as the missing acft were recovered from the bay during the 3 days following the flt of the acft. Other identified parts of…Sep 11, 1983 · N28077 · DestroyedNTSB ATL83FA366Accident · 1 fatalField investigationFinal reportPterodactyl/Lambert None · Mt. Holly, NCThe plt was on a x-country accompanied by a plt in another ultralight vehicle. The accident acft was faster, so the plt maneuvered around while en route. During a turn, the accident vehicle got out of sight from the plt of the other vehicle & became…Sep 10, 1983 · N2084Q · DestroyedNTSB FTW83LA422Accident · No injuriesLimited investigationFinal reportCessna 150G · Freer, TXReportedly, the non-rated plt encountered a loss of power after the fuel exhausted near the destination arpt. Subsequently, he made an emergency landing at night on umimproved terrain aprx 1 mi from the arpt. During the landing sequence, the acft bounced, the…Sep 6, 1983 · N3374J · Substantial damageNTSB LAX83FU015Accident · 1 fatalFinal reportWaspair Tomcat HM-81 · Roseville, CAThe plt had only flown 1 flt since he had crashed the same ultralight vehicle nearly 1 yr previously. An eye witness, who was president of the local ultralight association, had test flown the repaired vehicle before the plt flew it. The plt, the eye witness &…Sep 3, 1983 · UNREG · Substantial damageNTSB FTW83FA407Accident · 2 fatalField investigationFinal reportLuscombe 8C · Post, TXThe acft had impacted in a steep right wing down, nose low attitude. No preimpact, mechanical malfunction or failure was found. The plt's blood alcohol level was 0.054%. There were no entries in the plt's log book for previous flts in Luscombe acft.Aug 31, 1983 · N25285 · DestroyedNTSB MIA83LA212Accident · Minor injuriesLimited investigationFinal reportBell 47J · Labelle, FLWhile at an altitude of about 150 ft, the eng lost power. The plt initiated an autorotation, but during the landing, the main rotor struck trees & the helicopter was substantially damaged. The plt estimated there was 15 gal of fuel on board during the…Aug 26, 1983 · N5824 · Substantial damageNTSB FTW83LA399Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Albuquerque, NMThe plt reported that the eng lost power & he had to make a forced landing on desert terrain. The acft touched down short of the rwy near the coronado arpt & the plt received head injuries. The reason for the power loss was not determined. However, the temp &…Aug 25, 1983 · N2665U · Substantial damageNTSB SEA83AA176Accident · 5 fatalFinal reportFairchild Hiller FH-1100 · Toutle, WAThe helicopter took off on a sight-seeing, passenger flt in the mount st helens area. When the flt became overdue, a search was initiated. Later, the helicopter was found where it crashed & burned in a heavily wooded area on relatively level terrain, near the…Aug 13, 1983 · N29917 · DestroyedNTSB ANC83FA143Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Hope, AKThe acft crashed under unknown circumstances. The wreckage was removed after an aerial survey & has not been located.Aug 7, 1983 · N4301Z · Substantial damageNTSB LAX83LA468Accident · 3 fatalLimited investigationFinal reportMooney M20K · Essex, CAAn in-flight loss of control for undetermined reasons.Aug 6, 1983 · N3624H · DestroyedNTSB CHI83FA365Accident · 1 fatalField investigationFinal reportCessna 182 · Marseilles, ILThe acft was on a parachute jumping mission. After climbing to 9000 ft MSL, 4 sky divers jumped out & the plt began a descent back to the arpt. The acft was seen level at aprx 500 ft AGL & in the aprx position for a downwind leg for a left pattern for runway…Aug 6, 1983 · N6351A · DestroyedNTSB SEA83FA162Accident · 1 fatalField investigationFinal reportPiper PA-36 · Firth, IDAccording to witnesses, the acft was overheard returning to the strip for a second load. Reportedly, it went into a steep bank at about 70 ft AGL & turned toward the strip. As the wings leveled, sounds of high eng power ceased & the acft descend to the…Aug 2, 1983 · N57588 · DestroyedNTSB LAX83FA371Accident · 1 fatalField investigationFinal reportCessna 152 · Pleasanton, CAThe acft crashed in a steep nose down attitude in hilly terrain. Debris was scattered for about 100 ft but the acft did not travel after initial impact. The fuel tanks were ruptured and no fuel remained. The sheriff's deputies said no odor of fuel was noted…Jul 31, 1983 · N6599L · DestroyedNTSB NYC83FFJ03Accident · 1 fatalFinal reportSopwith Triplane · Allegany, NYThe owner/plt of the home built, Sopwith triplane took off on a local flt. This was the 1st flt since some maintenance rework & a new propeller installation. After the acft was airborne for aprx 20 min, it was observed flying at about 500 ft AGL. Reportedly,…Jul 22, 1983 · N5004 · DestroyedNTSB LAX83FVM09Accident · 2 fatalFinal reportTwitchell LONG-EZE · Oceano, CAThe acft was observed in a 3-4 turn spin until impact. A control stick was mounted on the right armrest in the rear cockpit. A complete set of controls; stick, rudder & throttle, was installed in the front cockpit.Jul 3, 1983 · N3149K · DestroyedNTSB FTW83FA302Accident · 2 fatalField investigationFinal reportCessna 150J · El Campo, TXThe acft impacted the ground in a steep nose down attitude. After impact, the acft remained in a tail-high attitude. No known witnesses observed the accident. An exam of the eng & prop showed a minimum of power being developed at the time of impact. A…Jun 29, 1983 · N60655 · Substantial damageNTSB ATL83FAMS1Accident · 2 fatalMissing aircraftFinal reportPiper PA-24 · Fleeton, VAOn July 2, a main landing gear, identified by the FAA as part of N7284P, was found floating in the chesapeake bay. The body of the deseased passenger was located on July 9, 1983 in the bay. Investigation revealed no record of communicationbetween the acft and…Jun 29, 1983 · N7284P · DestroyedNTSB FTW83FA280Accident · 3 fatalField investigationFinal reportBell 206B III · Eugene Isl.BlkThe helicopter was used to shuttle pax & supplies between various oil drilling platforms & was en route between two islands when the accident occurred. Wreckage was spotted 6 miles west of the destination island. Only the pilot's body was retrieved & 2 pax…Jun 16, 1983 · N5010U · DestroyedNTSB LAX83FVG12Accident · 1 fatalFinal reportYarnell Grass Hopper · Redding, CAThe acft crashed into steep mountainous terrain under unknown circumstances. The wreckage was 50 feet below a ridge line in deep brush. The engine and nose section were buried to the firewall. Eight inches of one prop blade showed aboveground and revealed no…Jun 4, 1983 · N80546 · DestroyedNTSB LAX83FA260Accident · 2 fatalField investigationFinal reportPiper PA-32 300C · Buckeye, AZThe acft collided with a utility pole about 36 ft AGL less than a mile north of a private dirt airstrip. The acft had departed scottsdale municipal arpt at about 0045. The accident occurred at about 0200 aproximately 4 miles west of Buckeye,AZ. A witness…Jun 1, 1983 · N8926N · DestroyedNTSB LAX83FA246Accident · 2 fatalField investigationFinal reportHerpst Varieze · Portola, CAThe home built acft collided with trees & crashed on rising terrain while the plt & passenger were on a sight-seeing flt. The accident occurred at an elevation of 7000 ft, the density altitude was estimated to be aprx 10000 ft. the wreckage was scattered aprx…May 23, 1983 · N882BF · DestroyedNTSB MKC83FU002Accident · 1 fatalFinal reportWeedhopper JC-24C · 5n Battle Creek, NEThe plt had assembled & flown the ultralight vehicle during the previous summer. This was his 1st flt after removing it from winter storage. He was observed preflighting the vehicle before takeoff. At about the time of the accident, a ground witness heard the…May 21, 1983 · UNREG · Substantial damageNTSB DCA83AA025Accident · 3 fatalFinal reportPiper PA-23 · Gaithersburg, MDThe owner/plt was on a flt, accompanied by two nephews, ages 19 & 8 yrs old. An associate of the owner/plt reported that the 19 yr old nephew, who occupied the right front seat, was a single eng plt, but had no multi-eng instruction. However, no FAA records…May 7, 1983 · N1236P · DestroyedNTSB LAX83IA216Incident · No injuriesIncident investigationFinal reportCessna C-172-N · Huntington Beac, CAThe left aileron sustained damag under undetermined circumstancea. A near miss was described by the pilot and could not be substantiated by radar.May 6, 1983 · N4913G · Minor damageNTSB NYC83FA106Accident · 2 fatalField investigationFinal reportBell 47G-2 · Waymart, PAThis was an introductory instructional flt. Witnesses observed the helicopter flying straight & level prior to the accident. The helicopter had impacted a 60-FT tree at about the 40-FT level. No preimpact failure/falfunction of either the airframe or engine…Apr 30, 1983 · N2829B · DestroyedNTSB MKC83FU001Accident · 1 fatalFinal reportAmerican Eagle 430B · Hartshorn, MOThe co-owner of the ultralight vehicle was watching the flt & observed the accident. He said the vehicle approached the pasture & was descending from aprx 200 ft as if the plt was going to land or fly by. The ultralight passed over the takeoff/landing area at…Apr 28, 1983 · UNREG · Substantial damageNTSB LAX83LA200Accident · No injuriesLimited investigationFinal reportBeech E-18S · Davis, CAWhile in flt on a parachute jumping mission, a fire erupted in the right eng area & a precautionary landing was made. An exam revealed that the float fulcrum screw, pn 13773, on the stromberg carburetor had backed out & allowed fuel to escape into the exhaust…Apr 16, 1983 · N4980V · Substantial damageNTSB ATL83FA161Accident · 1 fatalField investigationFinal reportCessna 177RG · Mobile, ALThe plt had not flown actively for aprx 1 yr. However, shortly before the accident, he had told friends that he had missed flying & was going to resume this activity. He received a checkout in the Cessna 177RG on 12/12/82 in anticipation of flying again. This…Apr 14, 1983 · N2765V · DestroyedNTSB LAX83LAMS4Accident · 1 fatalFinal reportCessna 152 · Missing AcftThe plt reportedly took off on a 1 hr local. The Acft did not return & was presumed to have crashed. Also, it was presumed to have been destroyed & the plt was presumed to have been fatally injured. The owner/operator provided info which suggested that the…Mar 29, 1983 · N6329M · DestroyedNTSB LAX83FA124Accident · 1 fatalField investigationFinal reportThorp T-18 · Simi, CAThe acft crashed in a school playground in a steep uncontrolled descent. Witnesses said the acft was observed in a 60 degree nose down attitude at about 1000 ft AGL and this continued until ground impact. The engine was producing high power at this time. No…Mar 5, 1983 · N3124 · DestroyedNTSB FTW83LA103Accident · Minor injuriesLimited investigationFinal reportCessna P337H · La Porte, TXShortly after lift-off, the acft started its initial climb, then entered a slow descent. The flight was continued until the acft collided with a tv cable, suspended below telephone cables on the same poles. The acft contacted the ground, bounced & became…Feb 3, 1983 · N4BX · Substantial damageNTSB ANC83FA042Accident · 3 fatalField investigationFinal reportBellanca 8GCBC · Melozi Hot Spgs, AKAcft deptd a private airstrip with no flt plan and was later reported overdue. Acft wreckage was found on sept. 27, 1984. Debris was scattered near the bottom of a 1000 ft box canyon cliff. The main fuselage was found in a lake at the bottom of the canyon.…Feb 1, 1983 · N8639V · DestroyedNTSB SEA83FA044Accident · 1 fatalField investigationFinal reportCessna P210N · Burns, ORThe plt was on a bank-check courier flt from troutdale to portland, with en route stops at Burns & redmond, OR. Routinely, the acft would depart troutdale between 0900 & 0930 & arrive at Burns at 1130 to 1200 local time. After a ground time of aprx 8 hrs, it…Jan 22, 1983 · N5162W · DestroyedNTSB ATL83LA078Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Daufuskie Islan, SCThe pilot's wife stated her husband had departed tampa, FL and could not recall if he had indicated a destination. She further stated her husband had a "charter". Investigation by law enforcement and drug enforcement personnel located cocaine in the aircraft…Dec 30, 1982 · N9305J · DestroyedNTSB MKC83FA046Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Bates City, MOThe aircraft crashed about 8 mi east of the departure airport after the non-instrument rated pilot took off on a dark night with fog and a low ceiling. The weather at the nearest reporting station was in part: 600 ft overcast, visibility 6 mi with fog.…Dec 27, 1982 · N2941Q · DestroyedNTSB ATL83FKJ01Accident · 1 fatalFinal reportCessna 172N · Clanton, ALThe acft was observed in a high speed glide to touch down briefly in a pasture at the top of a knoll. It then dropped below the rise & crashed in a wooded area adjacent to the pasture. Examination of the eng showed a crack extending from the top forward…Dec 22, 1982 · N609CW · DestroyedNTSB SEA83FA033Accident · 2 fatalField investigationFinal reportBell 214B · Near Randle, WAThe acft departed a private heliport & impacted a mountain at the 3,400 ft level. The wreckage was located about one mile east from the heliport. The impact site was hidden behind a ridge & is not visible from the heliport or the access road to the heliport.…Dec 18, 1982 · N244PH · DestroyedNTSB LAX83LXQ01Accident · 1 fatalFinal reportCessna T182RG · Bridgeport, CAThe acft hit a small pine tree located on the top of the ridge, then slid down a snow covered slope to the bottom of a ravine where it caught fire & burned. The pax was fatally burned & the plt received a severe head concussion. The prop was stopped at the…Dec 10, 1982 · N6166S · DestroyedNTSB ATL83FA049Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Ocean City, MDThe pilot and passenger bodies were recovered from the atlantic Ocean near Ocean City, MD. Both persons had died of drowning without serious traumatic injuries. The aircraft was not recovered. Low ceilings and visibilities were reportedin the area throughout…Dec 2, 1982 · N5284PNTSB CHI83FA049Accident · 2 fatalField investigationFinal reportAeronca 11CC · Spencer, WIThe acft was observed in a steep left turn at low altitude then impacting the ground straight down. Both propeller blades were bent back with no evidence of twisting. Approximately 1/2 inch of ice was found in the fuel line gascolator.Nov 27, 1982 · N4110E · DestroyedNTSB LAX83LUQ02Accident · 2 fatalFinal reportStinson 108 · Santa Barbara, CAThe aircraft collided with a power line as the pilot was flying at low altitude near a highway at dusk. After hitting the power line, the plane fell to the ground and burned. Witnesses reported there was a low cloud cover and light rain. One witness stated…Nov 23, 1982 · N222W · DestroyedNTSB LAX83LA028Accident · No injuriesLimited investigationFinal reportPitts S1 · San Andreas, CAThe acft had been airborne about 2 hrs & consumed over 23 gals of fuel when the eng quit due to fuel exhaustion. The operator stated this was considerably more then the normal fuel consumption of about 8 gals/hr. During the emergency landing the acft struck a…Nov 7, 1982 · N42JF · DestroyedNTSB DEN83FTM02Accident · 2 fatalFinal reportPiper J3C-65 · Near Holden, UTThe student pilot and his wife had flown from salt lake city to Holden, UT. According to his father, the plane crashed in an open field while the pilot was flying low and looking for a place to land. The plane crashed in an open grain field in about a 15 deg…Nov 6, 1982 · N67084 · Substantial damageNTSB MIA83LA025Accident · 3 fatalLimited investigationFinal reportBeech 65-B80 · Missing Acft, BahamasThe flt departed ft. lauderdale at 1626, & at 1654 in the vicinity of bimini was advised to contact nassau radio. The flt failed to contact nassau & there were no further communications with the flt. Search efforts produced negative results. IMC prevailed on…Nov 5, 1982 · N1HQ · DestroyedNTSB FTW83FAMS1Accident · 4 fatalMissing aircraftFinal reportPiper PA-34-220T · Durango, COThe aircraft originally departed helena, mt on a flight believed to be to taos, NM. A landing was made at ogden, ut where the plane was serviced with 47.5 gal of fuel. The last radio communication was at 1735 MST 11/2/82. At that time, the aircraft was…Nov 2, 1982 · N80960 · DestroyedNTSB FTW83LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Houston, TXThe aircraft struck a tree when the pilot was landing on a road. After tree impact, the aircraft spun around and crashed on the road sliding into a culvert and a telephone pole. The aircraft had been stolen and two occupants were observed to exit the aircraft…Nov 1, 1982 · N21136 · Substantial damageNTSB FTW83FRA01Accident · 3 fatalFinal reportPiper PA-28-140 · Woodville, TXAt about 2310 CDT, the owner/pilot and two other persons took off from the tyler county airport at Woodville, TX. About 15 minutes later, the plane crashed at the intersection of the runway (16/34) and a perpendicular taxiway. Impact and propeller strike…Oct 31, 1982 · N3858K · Substantial damageNTSB MIA83FA017Accident · 8 fatalField investigationFinal reportPiper PA-31 · Missing Acft (Atlantic Ocean)The flt departed anguilla at 0803 ast. At 0805 the plt radioed st. maarten & filed a VFR flt plan to st. thomas. The flt plan showed a direct route of flt at 4,500 ft MSL with a time enroute of 45 min. The flt failed to arrive at the destination. Search…Oct 20, 1982 · N777AA · Destroyed