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.
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" DESCRun 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 ATL99FA074Accident · 1 fatalField investigationFinal reportCessna 172 · Savannah, GAThe pilot's selection of the wrong runway for landing and his delayed go-around, which resulted in the collision with trees. A factor was the tailwind on landing.NTSB NYC99LA095Accident · No injuriesLimited investigationFinal reportCessna 152 · Wall, NJThe pilot in command's improper preflight preparation, which resulted in fuel exhaustion and subsequent loss of engine power.NTSB MIA99LA136Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLA loss of engine power due to fuel exhaustion and the pilot in command's failure to ensure that the aircraft had adequate fuel to complete the flight.NTSB LAX99FA150Accident · 2 fatalField investigationFinal reportBeech 36 · San Diego, CAThe pilot's failure to maintain the proper glidepath during an ILS approach. A factor in the accident was the pilot's disregard for the weather reports, which showed the airport as being below landing minimums.NTSB SEA99TA051Accident · Minor injuriesFinal reportI.C.A. Brasov IS-28B2 · North Plains, ORThe second pilot did not maintain clearance from power lines. The pilot-in-command did not adequately supervise the second pilot, and the second pilot's diverted attention and lack of familiarity with the geographic area were factors.NTSB MIA99FA126Accident · Minor injuriesField investigationFinal reportBeech E-55 · Lakeland, FLFailure of the pilot of the other aircraft to maintain a visual lookout and visual separation while on approach for landing. This resulted in a midair collision with another airplane and subsequent in-flight collision with the runway.NTSB SEA99LA049Accident · No injuriesLimited investigationFinal reportCessna 172N · Puyallup, WAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB FTW99LA115Accident · Minor injuriesLimited investigationFinal reportDavis/Cleaver Renegade 2 · Port Allen, LAThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI99LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Flint, MIThe loss of engine power for undetermined reasons. A factor associated with the accident was the lack of suitable terrain for a forced landing.NTSB ATL99LA069Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Nashville, TNThe pilot's inflight decision to land on a runway with a strong cross wind, rather then on a runway into the wind. A factor was the strong cross wind conditions.NTSB ANC99LA044Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Fairbanks, AKThe pilot's failure to attain the proper touchdown point on the runway. Factors in the accident were snow showers and snow-covered terrain.NTSB ATL99LA062Accident · No injuriesLimited investigationFinal reportCessna 210 · Opa Locka, FLThe loss of engine power for undetermined reasons.NTSB LAX99LA134Accident · No injuriesLimited investigationFinal reportCessna 172RG · Moorpark, CAThe failure and separation of the number two cylinder for undetermined reasons. A factor was the soft terrain at the forced landing site.NTSB SEA99LA044Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Port Angeles, WAThe pilot's improper in-flight decision which resulted in a loss of power due to a contaminated fuel system. Factors include unsuitable terrain and the fence.NTSB LAX99FA128Accident · 2 fatalField investigationFinal reportErcoupe 415E · Kingman, AZThe in-flight loss of airplane control due to rear wing spar attachment fitting failure. The failure resulted from severe corrosion that was undetected during performance of an inspection specified by an airworthiness directive. The airworthiness directive…NTSB IAD99FA034Accident · 2 fatalField investigationFinal reportBeech BE-76 · Dravosburg, PAThe pilot's failure to accurately calculate fuel required for the flight, and his decision not to divert for fuel prior to his intended destination. A factor in the accident was the pilot's over confidence in his ability to operate the airplane with minimal…NTSB LAX99LA116Accident · Minor injuriesLimited investigationFinal reportBell 206B · Delhi, CAThe pilot's failure to maintain clearance while landing in proximity to high vegetation, which resulted in the inadvertent contact of the spray boom to the trees.NTSB SEA99LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Salem, ORThe pilot-in-command's misjudgment of distance/altitude on final approach, and overload of the left main landing gear. A factor was the embankment at the end of the landing strip.NTSB CHI99FA102Accident · No injuriesField investigationFinal reportDouglas DC-9-15F · Kansas City, MOingestion of birds into both engines, resulting in foreign object damage and the subsequent partial power loss to both engines. A factor relating to this accident was the dark night.NTSB FTW99LA091Accident · No injuriesLimited investigationFinal reportCessna 172D · Homer, LAThe loss of engine power due to fuel starvation, as a result of fuel moving away from the fuel supply outlets. Factors were the low fuel level and the turbulence.NTSB FTW99LA089Accident · No injuriesLimited investigationFinal reportCessna 182C · Conway, ARThe total loss of engine power due to carburetor ice. Factors were the weather condition conducive to the formation of carburetor ice and the lack of suitable terrain for the forced landing.NTSB ANC99LA030Accident · Minor injuriesLimited investigationFinal reportInterstate S-1B1 · Anchorage, AKFuel starvation resulting from the pilot not understanding the fuel system procedures, and selecting the improper fuel selector position.NTSB DEN99LA045Accident · No injuriesLimited investigationFinal reportCessna 185 · Durango, COThe pilot's failure to maintain directional control and inadvertently allowing the airplane to ground loop. Factors were gusty crosswind conditions, pertinent crosswind information not made available by the manufacturer, and FAA's inadequate certification and…NTSB CHI99LA099Accident · No injuriesLimited investigationFinal reportCalkins Kitfox 5 · Waunakee, WIthe fracture of the trim actuator.NTSB IAD99LA031Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Sanford, METhe pilot mismanaged his fuel supply which led to fuel starvation and subsequent loss of engine power.NTSB CHI99LA095Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Kansas City, MOthe pilot's improper positioning of the fuel selector. Factors to the accident were the transmission wires, the building, and the flood levy wall.NTSB CHI99FA094Accident · 2 fatalField investigationFinal reportCessna 172C · Grenola, KSloss of control in flight due to incapacitation.NTSB NYC99IA062Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-320-231 · Columbus, OHa failure of the external o-rings in the nose landing gear steering module.NTSB LAX99LA099Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Ord, CAFuel exhaustion due to the pilot's becoming lost and disoriented during multiple attempts at completing an ILS approach.NTSB LAX99LA095Accident · No injuriesLimited investigationFinal reportBeech 95 · Henderson, NVa loss of power in one engine due to the student pilot inadvertently selecting the off position on one fuel selector valve while accomplishing the prelanding checklist. The instructor's inadequate supervision of the flight was also causal.NTSB ANC99FA028Accident · Serious injuriesField investigationFinal reportBeech 1900C · Saint Mary'S, AKThe pilot's descent below the minimum descent altitude on the instrument approach. Factors were pilot fatigue resulting from the pilot's rest period being interrupted by scheduling discussions and the night weather conditions of low ceilings and whiteout.NTSB NYC99FA060Accident · 1 fatalField investigationFinal reportCessna 170A · Leominster, MAThe pilot's failure to maintain the proper altitude during the approach.NTSB CHI99LA085Accident · No injuriesLimited investigationFinal reportBeech 1900D · Milwaukee, WIthe in-flight collision with a bird.NTSB MIA99FA075Accident · 1 fatalField investigationFinal reportCessna 210J · Naples, FLIn-flight collision with water while on base turn to final at night for undetermined reasons.NTSB LAX99FA091Accident · 1 fatalField investigationFinal reportCessna 150J · Mariposa, CAThe pilot's premature descent into terrain during a dark nighttime approach. Also causal was his physiological impairment due to alcohol. A contributing factor was his psychological condition.NTSB FTW99LA076Accident · Minor injuriesLimited investigationFinal reportBell 206-B3 · Sabine Pass, TXThe pilot's inadvertent flight into instrument meteorological conditions and subsequent spatial disorientation. Factors were the dark night conditions, the fog, and the pilot's failure to obtain a weather briefing prior to the flight.NTSB FTW99LA077Accident · No injuriesLimited investigationFinal reportBell 206L-3 · West Delta 105bThe pilot's failure to maintain clearance with the oil platform's windsock on final approach to landing.NTSB ATL99FA046Accident · 2 fatalField investigationFinal reportAero Commander 560A · Belleview, FLThe pilot's inadequate preflight planning of the fuel required for the flight that resulted in fuel exhaustion and the subsequent total loss of engine power to both engines.NTSB FTW99FA074Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Pearcy, ARThe pilot's failure to maintain the minimum descent altitude during the instrument approach. Contributing factors were the pilot's failure to follow the instrument approach procedure, trees, mountainous terrain, low ceilings and foggy weather conditions.NTSB CHI99LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · Rockford, ILthe failure of the pilot to maintain flying speed and ground clearance while on a night circling approach. Factors were existing icing conditions and the airframe and windshield icing.NTSB CHI99FA075Accident · 2 fatalField investigationFinal reportBeech BE-55 · Elkhart, INthe pilot failed to maintain a proper glidepath and obstacle clearance. Factors were the fog and dark night.NTSB CHI99FA072Accident · 3 fatalField investigationFinal reportBeech 95-C55 · Pellston, MIthe pilot's failure to maintain proper altitude/clearance on the approach and his flight into known icing conditions. Factors relating to this accident were the pilot flying with known equipment deficiencies, the pilot's physical impairment (alcohol), the…NTSB MIA99LA066Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW27 · Winter Haven, FLan in-flight collision with wires.NTSB SEA99LA030Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Moses Lake, WAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB ATL99FA044Accident · 2 fatalField investigationFinal reportBeech 300 · Cullman, ALThe pilot's failure to adhere to the missed approach procedure resulting in a collision with terrain. Contributing factors were fog and the rotorcraft rated pilot's lack of fixed wing certification/experience.NTSB LAX99LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Arlington, AZThe flight instructor's inadequate supervision of his student and his failure to initiate timely remedial action. Contributing factors were the student's failure to maintain the proper glidepath under the existing downdraft condition, the flight instructor's…NTSB FTW99LA066Accident · No injuriesLimited investigationFinal reportCessna 150H · Conway, ARThe loss of engine power due to carburetor ice during the approach to land. A factor was the lack of suitable terrain for the forced landing.NTSB ANC99FA021Accident · Minor injuriesField investigationFinal reportCessna 207 · Quinhagak, AKLoss of engine power due to fracture of the engine crankshaft, and the manufacturer's improper manufacturing procedure during engine assembly. Factors associated with the accident were the manufacturer's inadequate quality control standards, trees, and…NTSB SEA99FA028Accident · 2 fatalField investigationFinal reportPacific Aviation Composites LC 40-550FG · Portland, ORAircraft control was not maintained and the pilot's lack of total experience in type operation. Weather conditions reported ceilings below approach/landing minimums and a dark night condition were factors.NTSB FTW99LA065Accident · No injuriesLimited investigationFinal reportCessna 150M · Madisonville, TXThe loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.