NTSB investigations
3,371 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 WPR14TA236Accident · No injuriesFinal reportMcdonnell Douglas Helicopter 369E · Mesa, AZThe loss of engine power during cruise flight due to the decoupling of the engine’s turbine and compressor sections. Contributing to the decoupling was the excessive wear of the turbine-to-compressor coupling components due maintenance personnel’s placement…NTSB ERA14LA281Accident · Serious injuriesLimited investigationFinal reportBelew Marshall D II Steen Skybolt · Chapmansboro, TNThe pilot's failure to maintain airspeed while performing an emergency landing, which led to the airplane exceeding its critical angle-of-attack and experiencing a subsequent aerodynamic stall. Contributing to the accident was a partial loss of engine power…NTSB CEN14LA298Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Oneida, ARThe pilot’s inadequate fuel management, which resulted in a total loss of engine power at low altitude due to fuel exhaustion and a forced landing in a muddy field and subsequent nose-over.NTSB WPR14FA226Accident · 2 fatalField investigationFinal reportNorth American AT 6C · Buckley, WAThe loss of engine power during takeoff initial climb for reasons that could not be determined during a postaccident examination of the airplane.NTSB WPR14CA227Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Prescott, AZThe inadvertent activation of the engine's mixture control during cruise flight by the pilot undergoing instruction, which resulted in a total loss of engine power. Contributing to the accident was the flight instructor's inadequate monitoring of the pilot's…NTSB WPR14LA220Accident · Serious injuriesLimited investigationFinal reportAero Commander Callair A 9B · Gardiner, MTThe pilot’s inadequate preflight planning and his subsequent takeoff with the airplane over its allowable gross weight in high density altitude conditions, which degraded the airplane’s climb performance and led to a subsequent forced landing.NTSB CEN14LA267Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA20-C1 · Longmont, COA loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.NTSB ANC14LA034Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182K · Galena, AKA total loss of engine power for undetermined reasons, which necessitated a forced landing on unsuitable terrain, during which the airplane flipped over and became partially submerged in water.NTSB ERA14LA272Accident · Minor injuriesLimited investigationFinal reportLandrum Kelly T Vans RV6 · Suffolk, VAThe pilot/builder's decision to use a lubricant that was not designed for high-speed aviation applications, which resulted in the failure of the propeller needle thrust bearing due to the loss of lubrication from overheating, a total loss of aerodynamic…NTSB CEN14IA270Incident · No injuriesIncident investigationFinal reportBell 407 · Eugene Island 182AThe improper repair of the outer combustion case, which led to its ultimate failure due to the continued progression of a fatigue crack and resulted in a partial loss of engine power during takeoff.NTSB CEN14LA261Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Boulder, COThe pilot's failure to adequately monitor the airplane's actual fuel consumption rate, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN14LA263Accident · No injuriesLimited investigationFinal reportAero Commander 200D · La Grange, TXThe loss of engine power due to oil starvation for reasons that could not be determined based on the available evidence.NTSB ERA14LA261Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Cooperstown, NYThe pilot’s delayed use of carburetor heat during the approach to landing, which resulted in the formation of carburetor ice, a partial loss of engine power, and the airplane’s subsequent inability to sustain flight.NTSB CEN14LA253Accident · No injuriesLimited investigationFinal reportBeech A36 · Rockdale, TXA loss of engine power for reasons that could not be determined because postaccident testing revealed no anomalies.NTSB WPR14LA207Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Arvin, CAThe pilot’s failure to reconnect the air-oil separator return line after completing an oil change, which resulted in a total loss of engine power due to oil starvation.NTSB ERA14FA260Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA1B · Chester, SCThe pilot's inadequate inflight fuel monitoring, which resulted in fuel exhaustion and the subsequent total loss of engine power. Contributing to the accident was the loose fuel cap, which allowed fuel to syphon out in flight.NTSB ERA14LA253Accident · Serious injuriesLimited investigationFinal reportPiper J3C - 65 · Hopkinsville, KYThe failure of the pilot to identify poor engine performance during the engine run-up before takeoff. Also causal to the accident was the mistimed right magneto and the poor condition of the spark plugs in the No. 4 cylinder.NTSB ERA14LA248Accident · No injuriesLimited investigationFinal reportBell Helicopter Textron Canada 206 L4 · Beverly, MAMaintenance personnel’s inadequate inspection of the engine’s outer combustion case, which resulted in the failure of the case due to fatigue cracks that initiated on the inside surface of the case and the subsequent total loss of engine power.NTSB ERA14IA249Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Warren, VTThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA14LA242Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Georgetown, DEThe pilot’s improper preflight planning and in-flight fuel management, which resulted in fuel starvation and a total loss of engine power. Also causal to the accident was the pilot’s failure to see and avoid the wires on the airport boundary.NTSB WPR14FA194Accident · 1 fatalField investigationFinal reportAero Commander 500 S · Fort Huachuca, AZThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack after a total loss of engine power during the takeoff initial climb, which resulted in an aerodynamic stall and impact with terrain. The reason for…NTSB WPR14CA190Accident · No injuriesData collectionFinal reportAviat A 1B · Hayden, IDA partial loss of engine power due to encounter with weather conditions conducive to carburetor icing. Contributing the accident was the pilot's inadequate weather planning.NTSB CEN14LA235Accident · Minor injuriesLimited investigationFinal reportPazmany PL 4 · Yates City, ILA loss of propeller thrust due to a failure of the reduction drive unit resulting from the improper installation of the unit. Contributing to the accident was a lack of documentation for the reduction drive unit installation.NTSB CEN14LA233Accident · No injuriesLimited investigationFinal reportPiper PA 32-300 · Lancaster, OHFuel starvation due to the deterioration of the fuel selector valve, which allowed fuel to be fed from only the right tip tank. Contributing to the accident was the inadequate annual inspection, which failed to detect the deteriorated valve.NTSB WPR14LA240Accident · No injuriesLimited investigationFinal reportCessna T207A · Rock Springs, WYMaintenance personnel’s application of insufficient torque to the engine cylinder through bolts during replacement of the No. 1 cylinder, which resulted in the displacement of the No. 2 main bearing, the bearing shifting, and a catastrophic engine failure.NTSB ERA14LA223Accident · No injuriesLimited investigationFinal reportMesserschmitt-Bolkow-Blohm BK 117 · Hamburg, NYWear in the left cabin door assembly parts, which resulted in the door partially opening in flight, dislodging from the lower door track assembly, and then separating from the helicopter.NTSB ERA14LA219Accident · Serious injuriesLimited investigationFinal reportCzech Sport Aircraft A S Sportcruiser · Advance, NCThe pilot’s failure to apply carburetor heat during a descent with reduced engine power while operating in conditions conducive to carburetor icing, which resulted in a total loss of engine power.NTSB WPR14LA180Accident · Minor injuriesLimited investigationFinal reportBell 47G · El Monte, CAA partial loss of engine power during climbout due to a malfunctioning magneto and spark plugs.NTSB CEN14CA227Accident · No injuriesData collectionFinal reportPiper PA 24-250 · New Braunfels, TXThe loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight planning and inflight decision making.NTSB ERA14LA208Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Apex, NCA total loss of engine power during initial climb for reasons that could not be determined during postaccident examination and testing.NTSB CEN14LA218Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Wann, OKThe pilot's inadequate preflight inspection and planning and inflight fuel management, which resulted in a loss of engine power due to fuel exhaustion and a subsequent forced landing in an area of unsuitable terrain.NTSB CEN14LA226Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctls · Greenville, TXThe fatigue failure of the No. 4 cylinder exhaust valve due to excessive wear of the corresponding train tappet, which resulted in a total loss of engine power.NTSB ERA14CA206Accident · No injuriesData collectionFinal reportCessna 172I · Huntsville, ALThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB WPR14LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA30 - NO Series · Bullhead City, AZThe pilot's mismanagement of the throttle and propeller controls during the attempted go-around after encountering turbulence, which resulted in his failure to maintain adequate airspeed and climb rate and a subsequent forced landing and impact with terrain.…NTSB CEN14LA202Accident · 2 fatalLimited investigationFinal reportNanchang CJ6 - A · Flushing, MIThe pilot’s failure to maintain adequate airspeed during an off-airport forced landing after a loss of engine power due to carburetor icing and his exceedance of the airplane’s critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to…NTSB ERA14CA200Accident · No injuriesData collectionFinal reportKaldor Gregory N Zenith 701 · Eutaw Springs, SCThe pilot's improper decision to execute a precautionary landing to unsuitable terrain following an inflight encounter with a wind gust, resulting in substantial damage to the airplane.NTSB ERA14LA198Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Aguas Buenas, PRThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN14LA195Accident · No injuriesLimited investigationFinal reportLarsen Mark V · Amelia, OHThe distributor failure, which resulted in a total loss of engine power during cruise climb.NTSB ERA14LA193Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Louisa, VAThe pilot's decision to continue operation of the airplane with known mechanical issues (fluctuating oil pressure and metal in the oil filter), which was the result of undertorqued cylinder through bolts. Contributing to the accident was the mechanic's…NTSB ERA14CA189Accident · No injuriesData collectionFinal reportMoore Thomas O Zenith Stol CH701 · Frostproof, FLThe pilot's failure to maintain directional control during a precautionary landing. Contributing to the accident was the pilot's delayed decision to divert due to deteriorating weather.NTSB WPR14FA158Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Green River, UTA loss of engine power due to fuel contamination while maneuvering at a low altitude and the pilot's inadequate preflight inspection, which failed to detect the contamination.NTSB CEN14LA194Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Lee's Summit, MOThe pilots’ inadequate preflight planning and fuel management, which resulted in fuel exhaustion, a loss of engine power, and a forced landing on a soft field. Contributing to the accident was the flying pilot’s improper use of flaps during the forced landing.NTSB ERA14LA179Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Clayton, ALMaintenance personnel’s failure to properly torque the engine case through bolts, which resulted in the fatigue fracture of the crankshaft and subsequent total loss of engine power.NTSB ERA14LA183Accident · No injuriesLimited investigationFinal reportRobert J Reimbold Zenith CH 750 · Venus, FLThe fuel system’s inadequate design, which resulted in negative pressure in the right fuel tank and a total loss of engine power during cruise flight due to fuel starvation.NTSB ERA14LA178Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Bay St Louis, MSA sudden fuel leak, which resulted in a postlanding fire; the origin of the leak could not be determined due to fire damage.NTSB WPR14LA147Accident · No injuriesLimited investigationFinal reportCessna 172P · InarajanA total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA14LA167Accident · No injuriesLimited investigationFinal reportCessna O1 - A · St. Petersburg, FLThe pilot's improper in-flight fuel management, which resulted in fuel exhaustion in the selected tank and a subsequent loss of engine power due to fuel starvation.NTSB ERA14FA162Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Safety Harbor, FLThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's impairment due to cocaine use.NTSB ERA14LA161Accident · 1 fatalLimited investigationFinal reportCessna LC41-550FG · Palatka, FLThe pilot’s improper management of the fuel mixture and his failure to use the appropriate checklist and guidance during the flight, which resulted in an overrich mixture condition, carbon-fouling of the spark plugs, and a subsequent total loss of engine…NTSB CEN14CA164Accident · No injuriesData collectionFinal reportPiper PA 28R-201 · Ruidoso, NMThe pilot's failure to adjust the engine's fuel-air mixture and decision to takeoff in high density attitude conditions which degraded the airplane's performance.