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 FTW84FA374Accident · 1 fatalField investigationFinal reportMiller Air Sports GEM 260 · Martindale, TXNotes left by plt indicate he had been testing the flight envelope of this experimental racing acft, including operation of the engine beyond prop limit of 4000 RPM. Witnesses heard engine sound suddenly speed up to high RPM then cease altogether. Some…Sep 1, 1984 · N177M · DestroyedNTSB FTW84LA366Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Oak Grove, LAAircraft landed with a flat left main tire, veered left and nosed over inverted.Aug 24, 1984 · N528Y · Substantial damageNTSB FTW84LA356Accident · Serious injuriesLimited investigationFinal reportGulfstream 520 · Goliad, TXAcft was found abandoned. Wreckage scene indicates collision with trees prior to collision with terrain. Acft suspected of being used for illegal cargo operations.Aug 24, 1984 · N4183B · DestroyedNTSB LAX84FA421Accident · 3 fatalField investigationFinal reportFairchild Hiller FH-1100 · Meadview, AZPurpose of the flt was s sightseeing tour of lake mead, hoover dam and the western rim of the grand canyon. Before reaching the canyon the flt was to travel over a 5500 ft MSL ridge. The helicopter contacted a juniper tree at the bottom of a 3-sided canyon at…Jul 29, 1984 · N711KH · DestroyedNTSB FTW84LA330Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · San Marcos, TXWhile the plt was on a x-country flt, the acft crashed & came to rest on the shoreline of a large pond. Initial impact was believed to have occurred with the water. No preimpact part failure or malfunction was found during the investigation. There was…Jul 29, 1984 · N8685V · DestroyedNTSB ANC84LAMS1Accident · 5 fatalFinal reportCessna 401 · Anchorage, AKAt 0630 AKDT the plt obtained a wx briefing for the flt which forecast VFR with occasional marginal conditions along the route of flt. At 0704, the plt obtained an updated briefing at which time the destination of cantwell was reported IFR. At 0731 AKDT, the…Jul 25, 1984 · N7984Q · No damageNTSB BFO84FA001Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Selbyville, DEThe student pilot and one passenger departed on the flight without a wx briefing despite the existence of low ceilings and rain. Witnesses related hearing the engine accelerate and seeing the acft start a climb before it broke up and impacted the ground.…Jul 21, 1984 · N9014W · DestroyedNTSB NYC84FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 172N · Nantucket, MAThe acft disappeared after departing on the return leg of a x-country. The plt had called the operator at the home base and reported that IMC weather existed for the return. The plt was informed that the acft was not needed and he did not need to hurry back.…Jul 19, 1984 · N4950G · DestroyedNTSB FTW84FA291Accident · 2 fatalField investigationFinal reportCessna 152 · Minco, OKThe student plt had rented the acft. Records showed that he had flown this acft on previous occasions. The plt acting as instructor did not possess a current instructor certificate. There were no witnesses to the crash, but the acft was observed maneuvering…Jun 29, 1984 · N6473P · DestroyedNTSB MIA84FU006Accident · 1 fatalFinal reportStorey SKY PUP · Indiantown, FLThe ultralight experienced an in-flight separation of the left wing. The wing separated at the wing attachment fitting. The plt & ultralight had a parachute attached but it did not deploy.Jun 23, 1984 · UNREG · DestroyedNTSB MIA84LA186Accident · No injuriesLimited investigationFinal reportCessna A188B · Marianna, FLDuring a crop dusting operation, there was an apparent loss of power & oil sprayed on the windshield of the acft. The plt stated that when he applied power, there was no response. He made a forced landing on a road, but the right wing of the acft hit a tree.…Jun 18, 1984 · N5630G · Substantial damageNTSB MIA84FA188Accident · 1 fatalField investigationFinal reportCessna C-188 · Elkton, FLThe aircraft departed the farm grass strip for a spray mission estimated to take about 20 minutes. When the aircraft failed to return the pilots business partner started looking for the aircraft and pilot. The aircraft was found about one and one half mile…Jun 18, 1984 · N8233G · DestroyedNTSB LAX84LA354Accident · No injuriesLimited investigationFinal reportCessna T210N · Camp Verde, AZThe plt reported that during the landing, the acft rolled about 200 to 250 ft after touchdown, then began veering to the left. He attempted to maintain directional control by applying right rudder & brake, but was unusccessful. The left main gear hit a berm,…Jun 15, 1984 · N6406Y · Substantial damageNTSB LAX84FA328Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Baker, CAThe acft was found where it had crashed & burned on a rough lava bed. The crash site was about 1 mi northeast of a road where drug smuggling acft had been known to land in the past. There was evidence that cocaine had been removed from the accident site. The…Jun 2, 1984 · N6GW · DestroyedNTSB LAX84LAMS3Accident · 1 fatalFinal reportBellanca 17-31A · CABetween may 31 & June 1, 1984, the private plt is believed to have driven to the airport, parked his car, & boarded his aircraft for a presumed personal flt. The plt's wife became concerned about her husband's failure to appear at work, & she notified local…Jun 1, 1984 · N6602V · DestroyedNTSB FTW84FA258Accident · 1 fatalField investigationFinal reportCessna 152 · Fairview, OKThe acft had inflt structural failure and separation of some components and crashed in an inverted flat spin parts of the wing and aileron were never found. Some parts were found about 1/2 mile from the primary impact point. An autopsy onthe plt revealed the…May 31, 1984 · N49640 · DestroyedNTSB FTW84LA249Accident · No injuriesLimited investigationFinal reportBeech 65 · Zapata, TXAccording to law enforcement officers, the acft experienced double eng failure and made a forced landing in unimproved terrain. During the landing rollout the acft struck several trees. An intense post crash fire erupted destroying all but one wing tip of the…May 25, 1984 · N404C · DestroyedNTSB SEA84FA113Accident · 1 fatalField investigationFinal reportCessna 150F · Gleneden Beach, ORTwo witnesses observed the student plt in the acft at about 1500 PDT. They reported that they were waiting for the wx to clear & that they tried to get the student to spend the night instead of leaving, but they were unsuccessful. Subsequently, the acft…May 19, 1984 · N6511F · DestroyedNTSB FTW84LAMS4Accident · 1 fatalFinal reportPiper PA-32-260 · Lafayette, LAThe acft has been missing since 5/10/84. The owner called for his acft preflighted and departed on a southerly heading. An off shore oil rig spotted a twin engine acft heading south. Search efforts by cap were unsuccessful. The plt gave no indication of his…May 10, 1984 · N3545W · DestroyedNTSB ATL84FA168Accident · 2 fatalField investigationFinal reportCessna 172RG · Dallas, GAApproximately one-half hour after takeoff, the aircraft collided with rising terrain and was destroyed. The flight was unauthorized and no witnesses observed the crash. Weather at the time of the crash is unknown. The private pilot on board probably had not…May 6, 1984 · N6293V · DestroyedNTSB LAX84FA258Accident · 2 fatalField investigationFinal reportBellanca 7AC · Skull Valley, AZThe acft had been flown on several local flts, earlier that day. The last known flt originated at the ernest j love arpt, prescott, AZ, at 1600 MST. Subsequently, it crashed near the departure end of rwy 02 at the quarter circle 'j' arpt, which was in the…Apr 16, 1984 · N85034 · DestroyedNTSB MIA84LA137Accident · 1 fatalLimited investigationFinal reportGrumman American AA-5A · Clearwater, FLShortly after takeoff, the acft crashed into the ocean. VMC existed at the arpt but dense low ocean fog was reported at the crash site. Some acft debris was recovered.Apr 14, 1984 · N206JA · DestroyedNTSB FTW84FA193Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Houston, TXWitnesses heard the sound of an acft with the eng at high RPM. Shortly after that, they saw the acft in a left spin with the eng remaining at full power. The acft continued spinning until it crashed & burned. The witnesses noticed that when the plane was…Apr 9, 1984 · N4167Y · DestroyedNTSB MKC84FA119Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Memphis, MOThe acft broke apart during a x-country flt. Some thunderstorm activity & turbulence existed along parts of the planned route of flt. However, there was no known adverse wx in the vicinity of the crash site. About 25 mi southwest at kirksville, MD, the 0745…Apr 7, 1984 · N6902C · DestroyedNTSB FTW84FA190Accident · 1 fatalField investigationFinal reportBeech 65 · Jennings, LAA popping or backfiring sound was heard by several people who later observed the acft flying at low altitude on what appeared to be a final approach to rwy 13 at Jennings arpt (located about 75 mi sw of the departure point.) No radios were onboard the acft so…Apr 5, 1984 · N6RG · DestroyedNTSB MIA84LA128Accident · 4 fatalLimited investigationFinal reportCessna 172 · Marathon, FLThe acft was missing after departing on a flt from maraton, FL to everglades city, FL. Sar personnel found the bodies of the plt & 3 pax, but the acft was not found. It was presumed to have been destroyed during a crash in the gulf of Mexico.Apr 2, 1984 · N64110 · DestroyedNTSB MIA84FA126Accident · 6 fatalField investigationFinal reportCessna 402B · Missing Acft, MSThis Acft disappeared on a flt from ft lauderdale, FL to bimini, Bahamas. After departure, the Acft flt plan was activated by radio. This was the last communication with the Acft. An itap radar readout revealed an Acft flt that departed at the appropriate…Mar 31, 1984 · N44NC · DestroyedNTSB MIA84LA114Accident · 4 fatalLimited investigationFinal reportPiper PA-28-235 · Sanibel Island, FLThe acft failed to arrive at its destination. A satellite photo of the area showed wx & cloud cover between the departure & destination arpts. Radar data showed that an acft had left key west, FL, at about 1700, went northbound at 4500 until it encounter bad…Mar 12, 1984 · N39677 · DestroyedNTSB ANC84FA042Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Galena, AKThe plt took off on a reported low level hunting trip. During the flt, the acft crashed on snow covered terrain near a group of trees. It came to rest in a near vertical, nose down attitude with crushing damage on the nose & leading edges of the wings. There…Mar 12, 1984 · N5976D · DestroyedNTSB NYC84FA107Accident · 1 fatalField investigationFinal reportAmerican AA-1 · Scriba, NYAcft was located, after a 4 day search, in a gravel pit 8 miles from point of departure. Wreckage examination revealed acft collided with terrain in vertical descent with nil forward speed. Investigation of power plant revealed no evidence of torque or power…Mar 8, 1984 · N5649L · DestroyedNTSB MIA84FA091Accident · Serious injuriesField investigationFinal reportCessna 185F · Key West, FLThe acft landed after a previous flt & was refueled & preflight for another mission. According to maintenance personnel, the acft floats were drained once every morning before the 1st flt of the day in accordance with the manufacturer's recommendations. The…Feb 22, 1984 · N4460R · DestroyedNTSB MIA84LA089Accident · 2 fatalLimited investigationFinal reportCessna P-210N · Key West, FLDuring his wx briefing the plt was given the flight precautions & enroute forecast along his proposed route of flt. Enroute at 14,000 ft the plt advised ARTCC that the flt had encountered rime ice. The controller cleared the flt to descend to 12,000 ft & the…Feb 21, 1984 · N731NJ · DestroyedNTSB FTW84IA135Incident · No injuriesIncident investigationFinal reportNihon YS-11 · Tulsa, OKThe acft experienced a nose wheel steering malfunction & ran off the rwy during landing. The nose wheel system was removed from the acft & submitted for inspection & overhaul. Examination revealed that the lever shaft 'ears' had separated from fatigue.Feb 15, 1984 · N903TC · No damageNTSB DEN84FA086Accident · 1 fatalField investigationFinal reportCessna T210M · Sidney, MTRichland flt #101, a bank check courier flt, departed VFR with 180 lbs of cargo. Six minutes prior to the crash, the last radio transmission from the acft was heard concerning a routine landing wx advisory. The acft crashed aprx 45 degs nose low, gear & flaps…Feb 7, 1984 · N7399M · DestroyedNTSB FTW84FA122Accident · 2 fatalField investigationFinal reportBeech 77 · Fritch, TXThe acft departed on 1/27/84 and failed to return from a 2 hour local flt. Time of departure was 1330 CST. On 1/28/84, afisherman on lake meredith found an acft wheel floating in the water. This wheel was later found to have the same part numbers and paint as…Jan 27, 1984 · N3829D · DestroyedNTSB LAX84FA151Accident · 2 fatalField investigationFinal reportWells/Rand KR-2 · Santa Paula, CAWhile flying in an easterly direction, the acft collided with a 1/2 inch power line/ground cable, aprx 300 ft above the terrain. The impact occurred at mid-span. After colliding with the cable, the acft crashed & came to rest in an orchard. The sun was at an…Jan 21, 1984 · N42CW · DestroyedNTSB CHI84LA090Accident · No injuriesLimited investigationFinal reportCessna 210D · Rockford, ILThe plt was on a maintenance test flt to check the landing gear hydraulic power pac. He was unable to lower the main landing gear and landed with the nosewheel down. Examination of the hydraulic pac after the accident revealed that the hydraulic system had…Jan 19, 1984 · N502RF · Substantial damageNTSB FTW84FA114Accident · 2 fatalField investigationFinal reportBellanca 7ECA · Throckmorton, TXThe acft crashed in a steep left wing down, nose down attitude. The flt had been for the purpose of checking out the front seat plt on pipe line patrol. The front seat plt had only 22 hrs in this make & model. The weather was VMC and no mechanical…Jan 11, 1984 · N8646 · DestroyedNTSB LAX84LA217Accident · 3 fatalLimited investigationFinal reportCessna 182Q · Hana, HIThe acft disappeared from radar about 8 mi north of Hana, HI, while on an over-water flt. When it did not return from the flt, a search was intiated, but the acft was not found. Only the nose wheel strut (which washed ashore) and a life vest (found by…Jan 1, 1984 · N95811 · DestroyedNTSB LAX84FU024Accident · 1 fatalFinal reportEipper MX · Ramona, CAThe plt was flying the ultralight vehicle to check it out before allowing his student to solo. Aprx 15 min after the plt took off, he was flying over the arpt at about 400 ft AGL when witnesses heard a 'loud non-metallic' sound from the vehicle. At about that…Dec 28, 1983 · UNREG · DestroyedNTSB FTW84FA086Accident · 1 fatalField investigationFinal reportBeech D18S · Brownsville, TXThe plt had just taken off at night on a flt to Mexico when he declared an intent to return & land with some unspecified emergency. While he was using his radio, the sound of both engs, running at hi power, was audible. When asked if he required assistance,…Dec 6, 1983 · N44609 · DestroyedNTSB CHI84FAMS1Accident · 1 fatalMissing aircraftFinal reportMooney M20C · Near Green Bay, WIAfter a taking off at 2029 CST, the plt climbed to 7000 ft & flew on a southerly heading toward the oshkosh VOR. At 2030, the plt indicated that he had a radio problem, but he remained in radio contact with ATC until a freq change at 2039, then no further…Nov 22, 1983 · N9232M · DestroyedNTSB MIA84LA035Accident · 1 fatalLimited investigationFinal reportCessna 340A · Nr. Orangeville, FLThe acft disappeared fm radar coverage while in cruise flt at 10,000 feet MSL near Orangeville, FL. The ATC transcript revealed that the plt had been inquiring abt the weather ahead of him and was cleared to descend to 6000 in order to get below strong…Nov 20, 1983 · N85JK · DestroyedNTSB FTW84FA057Accident · 1 fatalField investigationFinal reportCessna 210N · Childress, TXThe plt contacte fss requesting info as to fuel service. He was advised that the rwy lights at Childress arpt was out of service. About 34 min later the plt stated his eng had quit & he would try to make the arpt. The acft subsequently struck power lines…Nov 16, 1983 · N6616N · Substantial damageNTSB DEN84FA231Accident · 4 fatalField investigationFinal reportCessna 182P · Climax, COThe wreckage of N7292S was located by the Colorado civil air patrol on July 22, 1984. An on-scene examination of the wreckage revealed that the acft had impacted tall pine trees in a near vertical right hand spiral maneuver. Impact forces destroyed the acft…Nov 14, 1983 · N7292S · DestroyedNTSB CHI84FA042Accident · 3 fatalField investigationFinal reportPiper PA-22-150 · Easton Township, MIThe acft crashed aprx 3 mi from the departure arpt. According to witnesses, it was flying at aprx 200 ft AGL when the right wing dipped & then the acft went nearly straight into the ground. An inspection of the airframe & flt control sys revealed no evidence…Nov 12, 1983 · N6903D · DestroyedNTSB CHI84LA038Accident · No injuriesLimited investigationFinal reportBeech A36 · Columbus, OHOn the return flt to Columbus, OH, the alternator warning light was on. After recycling the switch, the plt shut down all electrical equipment. During arrival at the destination, the plt put the gear handle down, but noted a dim unsafe gear light & a…Nov 5, 1983 · N6739U · Substantial damageNTSB ATL84LA035Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Greer, SCDuring the flt, hydraulic failure of the landing sys occurred & the aircrew were unable to get the gear locked in the down position. After orbiting for over an hour, a landing was made. During touchdown, the gear collapsed. An exam revealed that an aileron…Nov 1, 1983 · N40249 · Substantial damageNTSB ANC84FA013Accident · 4 fatalField investigationFinal reportCessna 206 · Kenai, AKThe acft departed nondalton, AK at aprx 1135 yst on a flt to Kenai, AK. At aprx 1215 yst, the plt report that he was over west forelands & requested the Kenai wx. About 4 min later, he requested a df steer to the Kenai arpt. A short time later, radio contact…Oct 31, 1983 · N9975 · DestroyedNTSB NYC84LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Wilkes-Barre, PADuring flt, the eng lost power from fuel exhaustion & the plt tried to land on a highway. According to witnesses, when he tried to maneuver into the northbound land, while traveling south, the right main gear hit the side of a bank. The wing fuel tanks were…Oct 15, 1983 · N7759G · Substantial damage