OpenAirDocs.org

NTSB investigations

20,992 cases where the phase of flight was Approach.

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 = 500)
  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 MIA82FA038Accident · No injuriesField investigationFinal reportPiper PA-34-200T · Newport Richey, FLThe pilot departed orlando, Florida on a VFR flight to tampa, Florida. At about 1534 EST, the pilot contacted tampa approach control for VFR flight following. Approach control reported radar contact, and at the same time, issued an advisory, "traffic at…Jan 23, 1982 · N32555 · 2 aircraft · Substantial damageNTSB FTW82DA049Accident · Minor injuriesFinal reportPiper PA-38-112 · Houston, TXThe pilot stated he encountered windshear while on short final for landing. The addition of full throttle by the pilot was insufficient to stop the descent before the aircraft impacted a small tree.Jan 23, 1982 · N2536K · Substantial damageNTSB MKC82FA019Accident · 1 fatalField investigationFinal reportCessna 402A · North Kansas Ci, MOThe pilot received 2 weather briefings. Most of the first briefing was spent finding an alternate. The forecast includedimc with low ceilings, low visibilities with light snow, fog, and possible freezing drizzle. The aircraft was not certificated for flight…Jan 22, 1982 · N4553Q · DestroyedNTSB ATL82FKJ11Accident · Serious injuriesFinal reportPiper PA-32 · Muscle Shoals, ALDuring the approach the pilot stated that he could not extend the landing gear. At some point during the approach the aircraft broke out into VFR conditions. The pilot stated he had the airport in sight when the aircraft struck a 160,000 volt power line.…Jan 22, 1982 · N31937 · DestroyedNTSB MIA82FA035Accident · 1 fatalField investigationFinal reportCessna 210 · Orlando, FLThe passenger stated that the aircraft departed with both fuel tanks indicating about 1/4 full. At 2113 the pilot reported to herndon tower that he had an engine failure. Accord to the surviving passenger, the only thing he saw the pilot do after the engine…Jan 21, 1982 · N3318S · Substantial damageNTSB ATL82FKQ10Accident · 1 fatalFinal reportPiper PA-23-250 · Mccomb, MSBefore taking off from jackson, MS, the pilot received a weather briefing by radio and filed an IFR flight plan to Mccomb, MS. During arrival at Mccomb, the weather was IFR with an indefinitely obscured ceiling at zero ft, visibility 1/2 mile in fog, wind 160…Jan 20, 1982 · N6242Y · DestroyedNTSB FTW82DA042Accident · No injuriesFinal reportCessna 150H · Shreveport, LAThe pilot departed stillwater, ok at 0950 CST on a flight to mcalister, OK. While airborne, he amended his destination to Shreveport, LA with an estimated arrival time of 1251 CST. On his flight plan, he estimated 3 hours of fuel on board. At 1253 CST, the…Jan 19, 1982 · N6510S · Substantial damageNTSB DCA82AA012Accident · 3 fatalFinal reportSwearingen SA226-T(B) · Rockport, TXPrior to the faf during a vor/dme approach, the merlin was cleared to change to the UNICOM freq. The plt of the merlin contacted UNICOM & requested an arpt advisory. The UNICOM operator replied that there was a PIREP of 500 ft over the field with 2 mi…Jan 19, 1982 · N336SA · 2 aircraft · DestroyedNTSB ATL82FA037Accident · 4 fatalField investigationFinal reportCessna 210L · Madison County, ALThe aircraft departed destin, FL at 1554 CST on a flight to tullahoma, TN. The estimated time en route was listed on the flight plan as 2.5 hrs with 4.5 hours fuel on board. During arrival at tullahoma, the pilot initiated a vor/dme-b approach, but executed a…Jan 19, 1982 · N641CH · Substantial damageNTSB FTW82FRG21Accident · 1 fatalFinal reportPiper PA-31 · Port Mansfield, TXThe aircraft crashed and burned about 1/2 mile from the approach end of runway 12. A witness reported that "the plane just fell" while the pilot was making a sharp turn. An estimated 1500 lbs of marijuana was on board.Jan 17, 1982 · N9181Y · DestroyedNTSB NYC82DA023Accident · No injuriesFinal reportCessna 150M · Swanton, VTDuring the initial takeoff, the pilot noted a partial loss of engine power at about 200 ft AGL. Carburetor heat was applied and power was restored. He flew the traffic pattern and landed, and then he made another preflight inspection and a full run-up. During…Jan 16, 1982 · N704KE · Substantial damageNTSB NYC82DA022Accident · No injuriesFinal reportCessna 310 · Butler, PAThe pilot arrived at the destination at dusk. He circled the airport at pattern altitude to check the wind and runway condition. He noted that the runway was covered with snow. A long approach was made to runway 36 in a calm wind condition. Just prior to…Jan 15, 1982 · N4875B · Substantial damageNTSB SEA82DA017Accident · No injuriesFinal reportPiper PA-31-350 · Spokane, WAAfter arriving in the Spokane area, a full ILS was commenced. It was terminated about 200 ft above the decision height with a missed approach. The aircraft was vectored for a second ILS. During the last 400 ft of this approach, about 3/4 to one inch of mixed…Jan 13, 1982 · N36PB · Substantial damageNTSB MIA82DA032Accident · Serious injuriesFinal reportPiper PA-23-250 · Okeechobee, FLThe aircraft owner and a friend were taken to a hospital emergency room with serious injuries at about 2115 local time. They stated that they had been attacked and robbed while hitch-hiking. On the next morning, the owner's aircraft was found where it had…Jan 10, 1982 · N567V · DestroyedNTSB FTW82DA039Accident · No injuriesFinal reportCessna 172 · Fruit Vale, TXThe pilot stated that during the approach he was momentarily blinded by the sun. The aircraft collided with the top wire on a fence at the end of the runway pulling it down onto the runway.Jan 9, 1982 · N7355A · Substantial damageNTSB DEN82FTE15Accident · No injuriesFinal reportCessna 182A · Steamboat Sprin, COAfter the pilot entered the traffic pattern for landing, he extended his downwind leg to accomodate the departure of another aircraft. The pilot reported that he pushed the throttle forward as he turned base, but the engine failed to respond. During a forced…Jan 9, 1982 · N2195G · Substantial damageNTSB MIA82FLD14Accident · 1 fatalFinal reportCessna 172M · Odessa, FLWhile maneuvering at low altitude, the aircraft struck a power line and crashed into a field about 1000 ft south of the airport. The accident occurred at night in heavy fog. An examination of the cable marks on the wreckage indicated the aircraft was in a…Jan 8, 1982 · N80264 · DestroyedNTSB CHI82FA024Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · New Philadelphi, OHWhile on final approach the aircraft contacted a tree about 70 feet high and 920 feet from the displaced threshold to runway 14. The pilot then elected to initiate a go-around and climbed straight ahead. After completing a 180 degree turn to downwind the…Jan 8, 1982 · N207CB · DestroyedNTSB ATL82DA031Accident · No injuriesFinal reportBeech V35 · Westminister, MDThe pilot reported encountering severe downdrafts and turbulence at the runway threshold. He stated that he applied full throttle, but the aircraft touched down prematurely and was angled about 30 degrees right of the runway heading. The aircraft came to rest…Jan 7, 1982 · N117P · Substantial damageNTSB MKC82DA016Accident · No injuriesFinal reportCessna 340 · Rolla, MOThe aircraft was certificated for flight into known icing conditions up to moderate icing. The pilot stated that the surface de-icers were operating during the preflight. During an instrument approach at the destination. The aircraft entered clouds at about…Jan 6, 1982 · N2672A · Substantial damageNTSB CHI82DA021Accident · No injuriesFinal reportCessna 152 · Paxton, ILDuring the student's last landing, the landing gear struck a snowberm at the approach end of the runway. Reportedly, the berm could not be seen from the air. After hitting the berm, the instructor took control of the aircraft and completed the landing. An…Jan 6, 1982 · N4900L · Substantial damageNTSB DCA82AA009Accident · 2 fatalFinal reportPiper PA-31 · Ithaca, NYThe acft was on a scheduled commuter flt from utica, NY to Washington, DC with a stop at Ithaca, NY. The en route portion of the flt from utica to Ithaca was normal. At 0735 EST, the acft was at 6000 ft MSL when apch control informed the aircrew to expect an…Jan 5, 1982 · N546BA · DestroyedNTSB LAX82IA034Incident · No injuriesIncident investigationFinal reportPiper PA-24-180 · Van Nuys, CAThe pilot did not get a gear down indication prior to landing. The tower and the pilot of another aircraft observed the left main landing gear not fully extended. After attempting to extend the gear for about two hours unsuccessfully, the pilot landed gear up…Jan 3, 1982 · N5018P · Minor damageNTSB FTW82DA036Accident · Minor injuriesFinal reportCessna 182 · Fort Worth, TXA witness stated that the pilot had attempted to land on the north-south runway but was unable to stay on the runway. The pilot then attempted to land into the wind on an east-west asphalt taxiway but the aircraft touched down short.Jan 3, 1982 · N71054 · Substantial damageNTSB DCA82AA008Accident · 8 fatalFinal reportCessna 414A · Ashland, VAThe plt received 2 wx briefings, one on the evening bfr the flt, another at 1009 EST, within 3 hrs of the tkof time. IFR conditions were forcasted at the uncontrolled, destination arpt. The plt filed an IFR flt plan, but did not list an alternate arpt. The…Jan 3, 1982 · N2620L · DestroyedNTSB ATL82FA033Accident · 1 fatalField investigationFinal reportBeechcraft BE-58 · Pinehurst, NCThe aircraft departed fulton county airport at 0306 EST and climbed to 13000 feet MSL. The flight was routine until approximately 0422 when the pilot of the unpressurized Beech 58 requested and was given a lower altitude. During the next 35 minutes the…Jan 3, 1982 · N10VS · DestroyedNTSB CHI82DA020Accident · No injuriesFinal reportCessna 150L · Charlotte, MIAfter returning to the airport, the pilot used full flaps during a crosswind landing. The wind was from 090 degrees, gusting 20 to 25 knots. The pilot stated that he added power when the aircraft stalled at about 10 ft AGL. The plane touched down in snow…Jan 2, 1982 · N1549Q · Substantial damageNTSB ATL82DA027Accident · No injuriesFinal reportBell 206L-1 · Chamblee, GAWhile returning to refuel from an air ambulance flight the helicopter yawed left and N2 dropped to about 92% approximately one mile from the airport. At 30-50 feet with airspeed at about 20 knots the aircraft yawed violently to the left with corresponding…Jan 2, 1982 · N5745Y · Substantial damageNTSB FTW82DA034Accident · No injuriesFinal reportPiper PA-28-161 · Hobbs, NMOn final approach to a gravel road the main landing gear collided with the upper strand of a powerline. The aircraft crashed in a pasture adjacent to the road. The student pilot was attempting to land at a family ranch.Jan 1, 1982 · N44832 · Substantial damageNTSB DCA82AA007Accident · 4 fatalClosedPiper PA-31 · Durango, CODec 31, 1981 · N41070 · DestroyedNTSB SEA82FA014Accident · 1 fatalClosedCessna 402C · Pullman, WADec 28, 1981 · N2749N · DestroyedNTSB DEN82FA013Accident · Serious injuriesClosedCessna T210M · Gunnison, CODec 28, 1981 · N732RN · DestroyedNTSB DEN82FA012Accident · 3 fatalClosedBeech E55 · Hayden, CODec 26, 1981 · N1766C · DestroyedNTSB DEN81DTA07Accident · Minor injuriesClosedCessna 152 · Big Timber, MTDec 23, 1981 · N5528B · Substantial damageNTSB ATL82FA030Accident · 2 fatalClosedPiper PA-32R · Wallace, NCDec 23, 1981 · N202DH · DestroyedNTSB LAX82FVG11Accident · Minor injuriesClosedGrum Amer AA-1B · Vacaville, CADec 22, 1981 · N1632R · 2 aircraft · Substantial damageNTSB ATL82FA025Accident · 1 fatalClosedBeech 24R · Greenville, SCDec 20, 1981 · N2517W · Substantial damageNTSB MIA82FLD10Accident · No injuriesClosedCessna 172M · Zephyrhills, FLDec 12, 1981 · N4657Q · Substantial damageNTSB FTW82FQG11Accident · Minor injuriesClosedCessna 421 · Perryton, TXDec 12, 1981 · N7574Q · DestroyedNTSB FTW81FA032Accident · 2 fatalClosedAero Comdr 690C · Patterson, LADec 12, 1981 · N5860K · DestroyedNTSB FTW82FA030Accident · 1 fatalClosedCessna 172 · Venus, TXDec 10, 1981 · N2894U · DestroyedNTSB FTW82DA031Accident · No injuriesClosedHawker Sidd HS.125 · Laredo, TXDec 10, 1981 · XA-ESQ · Substantial damageNTSB LAX82FUJ18Accident · No injuriesClosedCessna 172 · Tucson, AZDec 9, 1981 · N5384R · Substantial damageNTSB NYC82DNA09Accident · 2 fatalClosedCessna 172N · Nantucket, MADec 8, 1981 · N733PF · DestroyedNTSB ATL82FLG06Accident · Serious injuriesClosedPiper PA-23 · Hilton Head, SCDec 7, 1981 · N5295Y · DestroyedNTSB ATL82FLG05Accident · Minor injuriesClosedCessna 152 · Clemson, SCDec 6, 1981 · N64842 · Substantial damageNTSB CHI82FA017Accident · 1 fatalClosedPiper PA-28 · Preston, MNDec 5, 1981 · N6958T · DestroyedNTSB LAX82FVM03Accident · Minor injuriesClosedCessna T210N · San Francisco, CADec 3, 1981 · N765DS · Substantial damageNTSB MIA82FA015Accident · 2 fatalClosedMooney M20F · Richmond, VADec 1, 1981 · N7439V · DestroyedNTSB ATL82FID04Accident · 1 fatalClosedCessna 150 · Chesapeake, VADec 1, 1981 · N19291 · Destroyed