NTSB investigations
2,084 cases where the phase of flight was Standing.
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 = 150)
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 = 150)
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 WPR09CA155Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Douglas, AZThe pilot's failure to properly secure the helicopter prior to exiting the aircraft.NTSB CEN09LA198Accident · No injuriesLimited investigationFinal reportBell 206 · Galliano, LAThe failure of the tail rotor driveshaft and coupling during engine start due to the mechanic's failure to properly reattach the tail rotor driveshaft and coupling during maintenance.NTSB DCA09FA033Accident · No injuriesField investigationFinal reportBombardier CRJ · Tallahassee, FLAn electrical anomaly in the top portion of the JB-1 junction box resulting in ignition of adjacent combustible materials, including insulation blankets, and a flexible oxygen line.NTSB WPR09LA130Accident · 1 fatalLimited investigationFinal reportToland S/Thornburgh J Twin 503SL · Torrance, CAThe passenger’s inadvertent activation of the engine throttle.NTSB ERA09CA156Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Lexington, KYThe pilot's failure to maintain control of the helicopter during takeoff. Contributing to this accident was the interference of the flight controls by the heavy coat and boots the pilot was wearing.NTSB ERA09CA138Accident · No injuriesData collectionFinal reportMD Helicopter 369E · Atlanta, GAWind gusts during engine shutdown, which resulted in the main rotor blades contacting the tailboom.NTSB CEN09LA107Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Palenstine, TXThe failure of the pilot to ensure security of the cockpit switches before rotating the propeller.NTSB WPR09LA057Accident · 1 fatalLimited investigationFinal reportKaman K-1200 · Santa Clarita, CAThe helicopter's encounter with a gusty crosswind condition during engine start that exceeded the helicopter's demonstrated wind envelope.NTSB CEN09CA077Accident · No injuriesData collectionFinal reportPiper PA-15 · Pleasanton, TXThe pilot's failure to adequately secure the airplane while hand-starting the engine.NTSB ERA09CA122Accident · No injuriesData collectionFinal reportDassault-Breguet Falcon 50 · Asheville, NCThe pilot's failure to ensure that the airplane's wheels were properly secured before releasing the parking brake.NTSB WPR09LA040Accident · 1 fatalLimited investigationFinal reportCessna 152 · Atwater, CAThe second pilot's failure to see and avoid the rotating propeller after exiting the airplane.NTSB ERA09CA045Accident · No injuriesData collectionFinal reportRandall Amanda Rotorway · Middletown, DEThe student pilot’s excessive use of cyclic during the engine run-up. Contributing to the accident were the student pilot’s lack of overall experience and the gusting wind conditions.NTSB WPR09CA041Accident · No injuriesData collectionFinal reportWSK PZL Mielec M-18A · Mountain Home, IDThe pilot's inadequate preflight inspection, and, his failure to properly secure the aircraft as he left the cockpit with the engine operating, which resulted in the unoccupied airplane inadvertently becoming airborne and colliding with a fence and terrain.NTSB ERA09CA041Accident · Serious injuriesData collectionFinal reportCessna 172 · Frederick, MDThe passenger’s failure to avoid the rotating propeller after exiting the airplane. Contributing to the accident was the pilot’s failure to include deplaning procedures as part of the passenger safety briefing.NTSB WPR09TA012Accident · 1 fatalFinal reportBell 407 · Sedona, AZThe paramedic's failure to monitor and maintain clearance from the rotating main rotor blades after exiting the helicopter.NTSB SEA08LA182Accident · Serious injuriesLimited investigationFinal reportBoeing 777-300 · San Francisco, CAThe ground crewman's failure to follow the tow bar disconnect standard operating procedures.NTSB CHI08LA211Accident · 1 fatalLimited investigationFinal reportBell 47G-4A · Mayville, WIThe pilot's failure to maintain clearance with the rotating rotor blades after he exited the helicopter after landing.NTSB LAX08CA209Accident · Minor injuriesData collectionFinal reportAerostar International S-77A · Boulder, COAn encounter with a sudden gust of wind, which rendered the balloon uncontrollable and led to a collision with a tree.NTSB DCA08MA076Accident · No injuriesClass 1 · MajorFinal reportBoeing 767 · San Francisco, CAThe design of the supplemental oxygen system hoses and the lack of positive separation between electrical wiring and electrically conductive oxygen system components. The lack of positive separation allowed a short circuit to breach a combustible oxygen hose,…NTSB ANC08CA073Accident · Minor injuriesData collectionFinal reportCessna 510 · Norfork, VAThe tractor tug driver's failure to maintain clearance with the parked airplane.NTSB MIA08LA106Accident · No injuriesLimited investigationFinal reportEurocopter France AS350 B2 · Hiram, GAThe failure of the starflex arm during engine run-up due to inadequate inspection by maintenance personnel.NTSB LAX08LA146Accident · No injuriesLimited investigationFinal reportCessna P206A · Hollister, CAThe pilot's failure to maintain physical clearance from the other airplane while taxiing.NTSB CHI08CA122Accident · No injuriesData collectionFinal reportEvektor Aerotechnik SportStar Plus · Greenwood, INThe student pilot's failure to maintain control of the airplane during engine run-up.NTSB ENG08IA025IncidentIncident investigationFinal reportBoeing MD-11 · Singapore, SingaporeThe Center Landing gear (CLG) strut failed due to intergranular (IG) cracking resulted from a contamination of the surface from the chemical used to clean that area prior to painting.NTSB DFW08LA097Accident · 1 fatalLimited investigationFinal reportRaytheon B200 · Taylor, TXThe failure of the pilot and mechanic to ensure that the airplane was depressurized prior to actuating the door. Contributing to the accident was the failure of the vacuum system.NTSB DFW08CA071Incident · No injuriesData collectionFinal reportCessna 172S · Austin, TXThe pilot's failure to maintain control of the airplane while parked on the ramp with the engine running.NTSB DFW08LA055Accident · 1 fatalLimited investigationFinal reportPilatus PC-12/45 · Oklahoma City, OKThe line technician's failure to remain clear of the propeller. A factor was the night lighting conditions.NTSB DCA08IA019Incident · No injuriesIncident investigationFinal reportEmbraer 145 · Jamaica, NYthe failure of the elevator control rods due to exposure to high winds while the aircraft was parked overnight. Contributing to this incident was the failure of the existing airworthiness directive to adequately detect this discrepancy given the known…NTSB DEN08CA035Accident · No injuriesData collectionFinal reportBell 222 UT · Casper, WYHigh winds forcing the helicopter's main rotor blade to strike the helicopter vertical stabilizer and tail boom during engine start, causing substantial damage.NTSB SEA08CA027Accident · No injuriesData collectionFinal reportEurocopter France EC 130 B4 · Meadview, AZThe downward flexing of the standing helicopter's main rotor blades and subsequent impact with its tail boom as a result of another helicopter's rotor blade's vortices. .NTSB NYC08LA028Accident · 1 fatalLimited investigationFinal reportBell 407 · Morristown, TNThe pilot's failure to maintain adequate clearance from the idling main rotor blade. Contributing to the accident was the pilot's failure to comply with the manufacturer's procedure for securing the helicopter.NTSB ENG08IA001IncidentIncident investigationFinal reportBoeing 757-225 · Charlotte, NCThe truck beam fracture initiated by fatigue and stress corrosion cracking from pits that were present on the ID surface of the truck beam, under the protective finishes. Crack propagation occurred by alternating modes of stress corrosion cracking and fatigue…NTSB SEA08CA004Accident · No injuriesData collectionFinal reportPiper PA 28-151 · Salt Lake City, UTThe leak at the fuel line fitting, which resulted in a fire during engine start.NTSB LAX07CA286Accident · No injuriesData collectionFinal reportCessna 182F · Bakersfield, CAThe pilot's inadequate preflight inspection and pretakeoff checks during which he failed to remove the gust lock.NTSB LAX07CA282Accident · Minor injuriesData collectionFinal reportPiper J5A · Turlock, CAThe pilot's failure to properly and adequately tie down the airplane during the engine start operation.NTSB NYC07CA236Accident · No injuriesData collectionFinal reportRobinson R44 II · Nashville, TNThe pilot's failure to maintain control of the helicopter.NTSB CHI07CA313Accident · No injuriesData collectionFinal reportHasch Vans RV6 · Salem, OHThe loss of engine power due to the blocked cooling and induction systems because of the pilot in command's failure to remove the cowling covers before the flight. Factors were the pilot's misjudged landing glidepath, the pilot rated passenger's inability to…NTSB SEA07CA258Accident · Minor injuriesData collectionFinal reportBell 206-B2 · Rosamond, CAThe pilot's inadequate compensation for gusting variable winds encountered after landing. Factors include gusting, suddenly shifting winds, and a hangar near the spot where the helicopter had landed.NTSB DFW07IA193Incident · 1 fatalIncident investigationFinal reportCessna A188B · Colorado City, TXThe pilot's failure to maintain clear of the rotating propeller.NTSB DFW07CA189Accident · Serious injuriesData collectionFinal reportMitsubishi MU-2B-36 · Hobby Airport, TXThe failure of the ramp employee to maintain clearance from the rotating propeller. A contributing factor was the prevailing night conditions.NTSB ATL07CA103Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Immokalee, FLThe pilot left the helicopter unattended with the engine operating which resulted in an inadvertent rollover.NTSB DFW07LA155Accident · 1 fatalLimited investigationFinal reportBoeing 737-232 · Tunica, MSGorund service personal's removal of the portable stairway prior to the main cabin door being secured. Factors were the high winds and heavy rain.NTSB LAX07CA214Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Clarksburg, CAThe pilot's inadequate hand-prop starting procedure and failure to secure the airplane.NTSB LAX07IA191Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Phoenix, AZAn out of rig/jammed door. Contributing to the incident was the operator's inadequate maintenance program and the airframe manufacturer's inadequate response to the issue.NTSB NYC07LA121Accident · No injuriesLimited investigationFinal reportDouglas DC-9-31 · Syracuse, NYThe senior ground agent's failure to follow written procedures and directives.NTSB SEA07LA111Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Van Horn, TXClearance was not maintained after landing by the instructor pilot, which resulted in an on ground collision with the helicopter standing near the refueling pumps. The aircraft standing in the refueling area was a factor.NTSB CHI07CA101Accident · No injuriesData collectionFinal reportLuscombe 8A · Chippewa Falls, WIThe pilot intentionally leaving the airplane unoccupied during the engine start, which resulted in the unoccupied airplane traversing into a cornfield. A factor was the rough/uneven cornfield.NTSB SEA07LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Chiriaco Summit, CAEngine fire during start-up for undetermined reasons.NTSB ATL07LA057Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Atlanta, GAThe improper maintenance of the "B-nut" fitting adjacent to the fuel pump by maintenance personnel, resulting in a fuel leak and wing explosion.NTSB DFW07CA069Accident · Serious injuriesData collectionFinal reportCessna 172 · Lancaster, TXThe spectator's inadvertent contact with the turning propeller while the airplane was standing with the engine operating. A contributing factor was the dark night conditions.