NTSB investigations
3,368 cases where the sequence of events included Off-field or emergency landing.
Cases, newest first
Query with SQL
duckdb -csv -c "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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 ANC21FA028Accident · Minor injuriesClass 3 · FieldFinal reportPiper PA-18A · Anchorage, AKA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB GAA21WA057AccidentClass 5 · ForeignPartenavia P68 · Bhopal, IndiaNTSB CEN21LA168Accident · No injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Justin, TXThe total loss of engine power due to carburetor icing.NTSB WPR21LA141Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20B · Animas, NMThe pilot’s delayed use in the operation of carburetor heat which resulted in a loss of engine power due to carburetor icing.NTSB GAA21WA056Accident · 2 fatalClass 5 · ForeignCessna 208 · Ndetani, KenyaNTSB ERA21LA155Accident · Minor injuriesClass 3 · LimitedFinal reportSocata MS894A · Monroe, GAMaintenance personnel’s failure to properly inspect and maintain the airplane’s engine cowling latches, which resulted in the in-flight separation of the engine cowling and a subsequent forced landing.NTSB CEN21LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Poplar Bluff, MOThe pilot’s decision to make a precautionary landing in a field that contained soft terrain, which resulted in the airplane nosing over. Contributing to the accident was the pilot’s decision to fly without a printed VFR sectional chart to identify the…NTSB CEN21LA151Accident · 1 fatalClass 3 · LimitedFinal reportBeech 35 · Palestine, TXA total loss of engine power due to the flight crew incorrectly placing the fuel selector between fuel tank detents, which resulted in fuel starvation. Contributing to the accident was the lack of a placard on the fuel selector, the lack of obvious fuel tank…NTSB WPR21LA127Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150E · Marana, AZThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA21LA144Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Boynton Beach, FLA total loss of engine power for undetermined reasons.NTSB CEN21LA145Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver Mxii · Hattiesburg, MSThe total loss of engine power for undetermined reasons and the pilot’s failure to maintain clearance from the trees during the subsequent forced landing resulting in an impact with trees and terrain.NTSB ERA21LA137Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172B · Winchester, VAThe pilot’s delayed use of carburetor heat, which resulted in carburetor icing and a subsequent total loss of engine power.NTSB CEN21LA138Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182F · Millville, IAThe inadequate maintenance/inspection of the airplane, which resulted in a total loss of engine power due to oil starvation.NTSB CEN21LA133Accident · No injuriesClass 3 · LimitedFinal reportAero Commander S2R · Alamo, TXThe partial loss of engine power due to water-contaminated fuel.NTSB ERA21LA125Accident · Minor injuriesClass 3 · LimitedFinal reportTaylorcraft BC-65 · Columbia, SCA total loss of engine power due to carburetor icing, which resulted from the student pilot’s failure to use carburetor heat.NTSB WPR21LA107Accident · Serious injuriesClass 3 · LimitedFinal reportHughes OH-6A · Horseshoe Bend, IDA partial loss of engine power due to a leak in the fuel cell outlet valve.NTSB ERA21LA126Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Pahokee, FLA loss of main rotor rpm for reasons that could not be determined, which resulted in an autorotation and a subsequent hard landing and rollover.NTSB GAA21WA070Accident · Serious injuriesClass 3 · ForeignBell 212 · Región del Libertador Bernardo O´Higgins, ChileNTSB CEN21LA117Accident · Serious injuriesClass 3 · LimitedFinal reportZenair Zodiac 601HDS · Waller, TXThe total loss of engine power due to a disconnected fuel line, which resulted in fuel starvation.NTSB ERA21LA112Accident · No injuriesClass 3 · LimitedFinal reportCessna U206 · Denton, NCA partial loss of engine power for reasons that could not be determined based on available information.NTSB ERA21LA103Accident · No injuriesClass 3 · LimitedFinal reportTL Ultralight Sro Stingsport · Hollywood, FLThe inadequate maintenance and inspection of the fuel system, which resulted in a partial loss of engine power. Contributing was the pilot's mismanagement of the emergency approach and landing, which resulted in a runway overrun.NTSB WPR21WA090Accident · Serious injuriesClass 5 · ForeignCessna 210 · Chibuya, ZimbabweNTSB ERA21LA098Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 421B · Old Bethpage, NYThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a forced landing.NTSB CEN21LA107Accident · 2 fatalClass 3 · LimitedFinal reportHawker Beechcraft G58 · Credit, ARA loss of left engine power for undetermined reasons, which resulted in an emergency descent with one engine inoperative and inadvertent collision with transmission lines. Contributing to the accident was the pilot’s inability to respond appropriately to the…NTSB CEN21LA103Accident · No injuriesClass 3 · LimitedFinal reportCessna 172H · Cypress, TXA total loss of engine power due to fuel exhaustion.NTSB CEN21LA102Accident · 1 fatalClass 3 · LimitedFinal reportHughes 369D · Tuckers Crossing, MSThe pilot’s loss of helicopter control when the external saw contacted trees during an attempted emergency landing due to a main rotor transmission oil pressure warning. The reason that the pilot did not release the external saw from the helicopter during the…NTSB ERA21LA091Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Pleasant Valley, NYA total loss of engine power due to failure of the magnetos, which were not overhauled in accordance with the manufacturer’s time specifications.NTSB CEN21LA092Accident · 1 fatalClass 3 · LimitedFinal reportSonex Tailwheel · Burleson, TXA total loss of engine power due to engine seizure. Contributing to the accident was the pilot decision not to orbit the airport, as originally planned.NTSB ERA21LA080Accident · 1 fatalClass 3 · LimitedFinal reportSocata TB10 · Pembroke Pines, FLThe pilot’s failure to use carburetor heat in environmental conditions favorable for serious carburetor ice during a prolonged wait with the engine at a low power setting before takeoff, which resulted in a partial loss of engine power due to carburetor ice.…NTSB ERA21LA071Accident · 1 fatalClass 3 · LimitedFinal reportAnthony Mattioli AR-1 · San Mateo, FLA loss of engine power due to fuel contamination.NTSB ERA21LA075Accident · No injuriesClass 3 · LimitedFinal reportKolb Firestar · Durham, NCA total loss of engine power due to fuel starvation as the result of a degraded fuel primer check valve.NTSB WPR21LA068Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Ogden, UTThe partial loss of engine power for reasons that cannot be determined due to lack of available evidence.NTSB ERA21LA062Accident · No injuriesClass 3 · LimitedFinal reportErcoupe 415 · South Boston, VAThe improper installation of a fuel filter screen cover gasket, which resulted in its failure, fuel starvation, and a subsequent total loss of engine power during cruise flight. Contributing to the accident was the unapproved fuel sight gauge, which obscured…NTSB ERA21LA047Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL3 · Greenville, NCThe airplane’s collision with a bird during initial climb, which resulted in a forced landing.NTSB ERA21LA042Accident · Serious injuriesClass 3 · LimitedFinal reportRepublic RC3 · Advance, NCThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN21LA074Accident · No injuriesClass 4 · LimitedFinal reportZlin Savage Cub-S · Francis, OKThe pilot’s selection of unsuitable terrain for the landing, which resulted in a nose over when the airplane encountered soft sand during the landing roll.NTSB WPR21FA045Accident · 2 fatalClass 3 · FieldFinal reportCessna 177 · Langley, WAThe flight instructor’s failure to maintain airspeed, which resulted in an aerodynamic stall and subsequent loss of control while attempting to conduct an emergency landing. Contributing to the accident was a total loss of engine power as a result of…NTSB CEN21LA047Accident · Serious injuriesClass 3 · LimitedFinal reportErcoupe 415 · Ardmore, OKThe pilot’s improper decision to takeoff with 3 persons in a 2-place airplane and over maximum gross weight, and his failure to apply carburetor heat when the airplane’s engine experienced carburetor ice and a partial loss of power.NTSB ERA21LA030Accident · Minor injuriesClass 3 · LimitedFinal reportGrumman AA5 · Baxley, GAA partial loss of engine power for undetermined reasons.NTSB WPR21LA020Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Show Low, AZA partial loss of engine power due to the failure of the No. 4 cylinder exhaust valve.NTSB CEN21LA031Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Buda, TXAn improperly torqued oil line fitting during an engine overhaul, which resulted in oil exhaustion and a total loss of engine power.NTSB WPR21LA017Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Puyallup, WAA partial loss of engine power as a result of carburetor icing and the flight instructors failure to use carburetor heat.NTSB ERA21LA024Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R22 · Winder, GAMaintenance personnel’s failure to properly secure the engine cooling fan attachment bolts, leading to vibration of the cooling fan, the overextension of the tension belt actuator, the failure of the drive system vee-belts, and the loss of power to the rotor…NTSB ERA21LA022Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Moneta, VAThe fight instructor’s failure to ensure that the fuel selector handle was in the correct position, which resulted in a total loss of engine power during initial climb due to fuel starvation.NTSB ERA21LA009Accident · Minor injuriesClass 3 · LimitedFinal reportWatson Michael A Velocity Elite RG · Lady Lake, FLA total loss of engine power during cruise flight for undetermined reasons.NTSB CEN21LA002Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Byers, COA partial loss of engine power for undetermined reasons.NTSB CEN21LA005Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT402 · Egypt, ARThe pilot’s failure to maintain clearance from a tree limb during a low-level aerial application flight.NTSB ERA21LA005Accident · No injuriesClass 3 · LimitedFinal reportFokker DR1 · Wake, VAA total loss of engine power due to fuel starvation as the result of the improper installation of the ram air fuel vent tube, which resulted in the tube separating from the airplane during taxi and subsequent negative pressure inside the fuel tank.NTSB ERA20LA341Accident · No injuriesClass 3 · LimitedFinal reportTecnam P92 · Centerville, MDThe fatigue failure of the No. 1 cylinder exhaust valve spring retainer due to air trapped in the lubrication system, which resulted in a total loss of engine power.NTSB CEN20LA424Accident · Serious injuriesClass 3 · LimitedFinal reportKitfox Speedster · Leadville, COA partial loss of engine power due to fuel starvation as a result of the pilot’s improper maintenance.