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 DCA94MA065Accident · 37 fatalClass 1 · MajorFinal reportDouglas DC-9-31 · Charlotte, NC1) The flightcrew's decision to continue an approach into severe convective activity that was conducive to a microburst; 2) the flightcrew's failure to recognize a windshear situation in a timely manner; 3)the flightcrew's failure to establish and maintain…Jul 2, 1994 · N954VJ · DestroyedNTSB CHI94LA220Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Garden City, KSfuel exhaustion for reason or reasons undetermined. A factor was the rough/uneven terrain.Jul 2, 1994 · N901JM · Substantial damageNTSB ANC94IA075Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Juneau, AKThe failure of the local controller to exercise his responsibility to have each aircraft adjust its flightpath to remain clear of the other, and the failure of the pilot of the Cessna 185 to maintain adequate visual separation from the Boeing 737.Jul 2, 1994 · N769AS · 2 aircraft · No damageNTSB BFO94LA123Accident · No injuriesLimited investigationFinal reportSchweizer 2-33 · Waynesville, OHThe instuctors inadequate supervision of the student who misjudged distance/altitude.Jun 29, 1994 · N65807 · Substantial damageNTSB BFO94LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Germansville, PAThe pilot failed to maintain a proper descent rate which resulted in an undershoot.Jun 28, 1994 · N3807M · Substantial damageNTSB BFO94FA120Accident · 2 fatalField investigationFinal reportBeech 76 · Elizabeth, PA1) The failure of the pilot-in-command (CFI) to provide adequate supervision of the dual student during a simulated single-engine approach, and 2) his failure to perform remedial action. This led to a loss of aircraft control in close proximity to the ground.…Jun 28, 1994 · N6004E · DestroyedNTSB CHI94FA209Accident · Serious injuriesField investigationFinal reportCameron CAN-56 · West Chicago, ILthe pilots failure to maintain vertical clearance above powerlines which bordered the field in which he intended to land. A factor associated with the accident were the powerlines.Jun 25, 1994 · N20367 · DestroyedNTSB ATL94LA125Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Kitty Hawk, NCThe pilot's improper compensation for the wind conditions, his improper recovery from a bounced landing, and the inadvertent stall. Factors were the wind conditions and the trees that bounded the runway.Jun 25, 1994 · N54920 · Substantial damageNTSB ANC94LA071Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's inadequate compensation for the wind conditions during the landing. The gusty wind condition was a factor.Jun 25, 1994 · N9869D · Substantial damageNTSB DCA94MA061Accident · 12 fatalClass 1 · MajorFinal reportLearjet 25D · Chantilly, VAThe poor decisionmaking, poor airmanship, and relative inexperience of the captain in initiating and continuing an unstabilized instrument approach that led to a descent below the authorized altitude without visual contact with the runway environment.…Jun 18, 1994 · XABBA · DestroyedNTSB BFO94LA106Accident · No injuriesLimited investigationFinal reportMooney M20C · Leesburg, VAThe pilot's failure to maintain the minimum descent altitude until the published approach fix. Factors related to the accident was pilot fatigue, low ceilings, obscuration, and fog.Jun 18, 1994 · N6679U · Substantial damageNTSB BFO94FA103Accident · 3 fatalField investigationFinal reportBeech A-36 · Brainerd, MNThe pilot's failure to follow the published missed approach procedure, and his failure to obtain and/or maintain adequate altitude to avoid collision with the terrain. Factors in the accident were: the pilot's lack of instrument flying experience, and the…Jun 17, 1994 · N1525G · DestroyedNTSB FTW94LA199Accident · No injuriesLimited investigationFinal reportCessna T210N · Santa Teresa, NMA power loss due to engine driven fuel pump failure. A factor was the lack of suitable terrain for a forced landing.Jun 16, 1994 · N199CH · Substantial damageNTSB FTW94LA194Accident · No injuriesLimited investigationFinal reportCessna 177 · Watonga, OKWas the pilot's failure to maintain the proper glidepath, his failure to compensate for existing wind conditions, and his failure to maintain clearance with the fence. A factor was the weather.Jun 13, 1994 · N2867X · Substantial damageNTSB LAX94LA253Accident · No injuriesLimited investigationFinal reportSchumacher Swearingen SX-300 · Kingman, AZthe pilot's inadvertent raising the flaps during a go-around attempt. A factor in the accident was the gusty crosswind condition.Jun 12, 1994 · N2H · Substantial damageNTSB ATL94LA120Accident · No injuriesLimited investigationFinal reportBeech P35 · Bluffton, SCA loss of engine power due to oil starvation. This resulted from an undertorqued condition of the oil filter adapter, and the subsequent fretting of the adapter threads.Jun 12, 1994 · N982Q · Substantial damageNTSB FTW94LA190Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Canton, TXWas the undershoot of the runway threshold due to the pilot's failure to attain the proper touchdown point, and his failure to compensate for the wind condition. A factor was the crosswind.Jun 9, 1994 · N5632P · DestroyedNTSB LAX94LA237Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Upper Lake, CAThe pilot's failure to maintain adequate airspeed during a go- around. Contributing factors were the pilot's delayed remedial action in initiating the go-around and his improper use of the carburetor heat during the attempted initial climb.Jun 4, 1994 · N94509 · Substantial damageNTSB CHI94LA187Accident · No injuriesLimited investigationFinal reportBeech C-23 · Gary, INImproper preflight planning and preparation by the pilot-in-command which resulted in fuel exhaustion. A factor associated with the accident was the delay in emergency procedures by the pilot-in-command.Jun 4, 1994 · N18893 · Substantial damageNTSB BFO94LA089Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Troy, NYThe pilot's inadequate compensation for the wind conditions and failure to maintain alignment with the runway which resulted in an inflight collision with a tree. A factor is crosswinds.Jun 4, 1994 · N2480J · DestroyedNTSB MIA94LA152Accident · No injuriesLimited investigationFinal reportCessna 210L · Pahokee, FLThe improper positioning of the fuel selector valve by the pilot-in-command which caused an engine failure due to fuel starvation at an altitude too low for restart procedures.May 31, 1994 · N76GH · Substantial damageNTSB LAX94LA230Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Chino, CAThe right engine's failure for undetermined reasons to respond to throttle command during a go-around attempt, and both pilot's failure to maintain directional control of the aircraft. Inadequate supervision of the flight by the CFI is also considered a cause.May 31, 1994 · N4810T · Substantial damageNTSB FTW94LA189Accident · No injuriesLimited investigationFinal reportBeech 35 · Mckinney, TXThe ailerons being locked by a foreign object.May 29, 1994 · N3956N · Substantial damageNTSB SEA94FA129Accident · 3 fatalField investigationFinal reportCessna 182B · Rock Springs, WYAn excessive descent rate in the turn from base to final. Factors include a dark night, high winds, and the pilot's fatigue from his flight and ground schedule the day of the accident.May 28, 1994 · N2582G · DestroyedNTSB ATL94LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Hartford, ALThe student pilot's inadequate compensation for gusting wind conditions during the approach to land. Factors were the instructor pilot's inadequate supervision of his student, the gusting wind conditions, and the trees located in close proximity to the runway.May 26, 1994 · N73846 · Substantial damageNTSB ANC94LA057Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Kenai, AKFuel exhaustion as a result of the student pilot-in-command's failure to refuel. The lack of suitable terrain for a forced landing was a factor.May 24, 1994 · N94583 · DestroyedNTSB MIA94LA147Accident · Minor injuriesLimited investigationFinal reportErcoupe 415D · Boynton Beach, FLInadvertent use of the mixture control while on final approach to land. Contributing to the accident was the separation of the mixture control cable from the carburetor.May 22, 1994 · N93763 · Substantial damageNTSB ATL94LA103Accident · Serious injuriesLimited investigationFinal reportFairchild M-62 · Hendersonville, NCThe failure of the pilot to maintain airspeed while maneuvering in the traffic pattern, resulting in an inadvertent stall.May 22, 1994 · N61845 · DestroyedNTSB NYC94LA089Accident · 1 fatalLimited investigationFinal reportTownsend, H.L. Briegled BG-12A · Readington, NJThe pilot failed to maintain airspeed while maneuvering which resulted in an inadvertent stall/spin. A factor was the lack of experience in the make and model of glider.May 21, 1994 · N6552N · DestroyedNTSB NYC94LA088Accident · 1 fatalLimited investigationFinal reportAeronca 11AC · Berwick, METhe pilot's inadequate preflight which fail to detect proper operation of the elevator which resulted in the loss of control inflight. A factor is inadequate maintenance which consisted of misrigging of the elevator flight controls.May 21, 1994 · N3167E · DestroyedNTSB NYC94LA087Accident · No injuriesLimited investigationFinal reportLutz Acro Sport II · Hornell, NYThe pilot's failure to maintain a proper glidepath. A factor in this accident was the pilot's lack of total experience in this type of airplane.May 21, 1994 · N5181V · Substantial damageNTSB FTW94LA169Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Bryan, TXThe pilot's failure to refuel resulting in a total loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.May 21, 1994 · N6372A · Substantial damageNTSB CHI94LA167Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Wausaukee, WIthe pilot's inadequate preflight of the airplane.May 21, 1994 · N7867H · Substantial damageNTSB LAX94LA221Accident · Minor injuriesLimited investigationFinal reportBell 206A · Ukiah, CAthe pilot's inadequate compensation for the existing wind conditions which resulted in a loss of tail rotor effectiveness event and a subsequent loss of directional control.May 20, 1994 · N206HS · DestroyedNTSB SEA94LA119Accident · 1 fatalLimited investigationFinal reportHallstrom BD-5B · St. George, UTCarburetor contamination and low output, and the pilot's improper decision to attempt to continue the approach. A factor was the pilot's lack of recent flight experience.May 17, 1994 · N224FH · DestroyedNTSB ATL94LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Andrews, SCThe failure of the pilot to maintain directional control of the aircraft.May 16, 1994 · N211SP · Substantial damageNTSB NYC94LA081Accident · No injuriesLimited investigationFinal reportLet Super Blanik L-33 · New Castle, VAThe pilot's improper use of the flight controls resulting in failure to maintain a proper descent rate during the approach for landing. A factor in this accident was the pilot's lack of total experience in this type of glider.May 15, 1994 · N23BR · Substantial damageNTSB NYC94LA080Accident · No injuriesLimited investigationFinal reportDavis DK-1 · East Haddam, CTThe pilot's failure to maintain the proper glidepath during landing approach.May 15, 1994 · N158Y · Substantial damageNTSB MIA94FA141Accident · 1 fatalField investigationFinal reportBeech 95-55 · New Port Richey, FLThe pilot's feathering of the wrong propeller after an engine failure for undetermined reason(s).May 15, 1994 · N9319Y · DestroyedNTSB FTW94LA157Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · San Antonio, TXThe pilot continued flight into known adverse weather. The thunderstorm activity was a factor.May 15, 1994 · N56971 · DestroyedNTSB ATL94FA099Accident · Serious injuriesField investigationFinal reportBeech 58 · Monroe, NCThe pilot's inadequate pre-flight inspection.May 15, 1994 · N66Q · Substantial damageNTSB MIA94LA139Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Fernandina, FLThe pilot in command's improper use of flight controls and his failure to maintain airspeed resulting in an inadvertent stall and uncontrolled descent to ground impact.May 14, 1994 · N99998 · Substantial damageNTSB FTW94LA161Accident · No injuriesLimited investigationFinal reportCessna 150J · Del Rio, TXFuel exhaustion induced power loss due to the pilot's inaccurate fuel consumption calculations. The lack of suitable terrain for the forced landing was a factor.May 14, 1994 · N51150 · Substantial damageNTSB CHI94FA157Accident · 4 fatalField investigationFinal reportBellanca 17-30A · Camdenton, MOThe pilot's failure to maintain control of the aircraft. A factor was his lack of experience flying in actual instrument flight conditions.May 14, 1994 · N4226B · DestroyedNTSB MIA94LA135Accident · No injuriesLimited investigationFinal reportBeech A35 · St. Petersburg, FLFailure of the pilot-in-command to maintain airspeed and proper glidepath resulting in the in-flight collision with trees short of the airport property.May 10, 1994 · N620B · Substantial damageNTSB FTW94LA185Accident · No injuriesLimited investigationFinal reportCessna 195 · Ama, LAThe pilot-in-command's failure to maintain adequate airspeed above the aerodynamic stall speed.May 8, 1994 · N999V · Substantial damageNTSB ATL94FA093Accident · 1 fatalField investigationFinal reportNord 1101 · Spartanburg, SCThe pilot's failure to maintain adequate airspeed while maneuvering for an emergency landing. A factor in the accident was an inflight fire from an undetermined source.May 7, 1994 · N1101A · DestroyedNTSB LAX94LA210Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-34 · Hemet, CAthe pilot's failure to maintain an adequate airspeed while maneuvering in the traffic pattern, which resulted in an inadvertent stall/spin. A factor in the accident was the pilot's low total flight time.May 3, 1994 · N1163S · DestroyedNTSB SEA94FA111Accident · Serious injuriesField investigationFinal reportCessna TU206G · Gold Bar, WAElectrical system short. Factors to the accident were: mountainous terrain and procedures/directives not followed.Apr 30, 1994 · N732JK · Substantial damageNTSB MIA94LA130Accident · Serious injuriesLimited investigationFinal reportAir Creation GTX Trike · Englewood, FLWas the failure of the pilot-in-command to maintain airspeed resulting in an inadvertent stall at an altitude insufficient for recovery.Apr 30, 1994 · UNREG · Substantial damage