NTSB investigations
902 cases where the first occurrence was “Miscellaneous/other”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 430) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 430) 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 LAX00FA213Accident · No injuriesField investigationFinal reportCessna 414A · Prescott Valley, AZThe pilot's physical impairment due to the cumulative effects of carbon monoxide from engine exhaust by-products, carbon monoxide from heavy tobacco use, and the loss of an undetermined amount of cabin pressurization. A factor in the loss of pressurization…NTSB MIA00LA175Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincolnton, NCThe inadequate supervision of the student pilot by the CFI for his failure to note that the student was performing a go-around from a low pass with 30-degree of flaps extended instead of the POH recommended 20-degrees. A factor in the accident was the failure…NTSB MIA00LA174Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Milledgeville, GAThe operation of the airplane by the pilot-in-command in an over gross weight condition, the failure of the pilot to maintain airspeed (Vs) after takeoff, and the intentional stalling of the airplane by the pilot-in-command for his attempting to bank while…NTSB MIA00LA169Accident · Serious injuriesLimited investigationFinal reportBoeing 737-500 · Nashville, TNThe passenger's onboard disturbance and self-evacuation from the parked aircraft, resulting in injuries. A factor in the accident was the lack of backup electrical power to the terminal which necessitated a lengthy ground hold.NTSB SEA00LA088Accident · Minor injuriesLimited investigationFinal reportAvions Mudry et Cie CAP 231 · Ephrata, WAThe pilot's failure to maintain aircraft control subsequent to the aircraft's canopy opening in flight. Factors include the pilot's failure confirm that the aircraft's canopy was secured prior to takeoff and impaired vision.NTSB MIA00IA164Incident · No injuriesIncident investigationFinal reportBeech 1900C · Fort Lauderdale, FLThe failure of the first officer to comply with procedures and directives for his failure to assure that the forward airstair door was closed and locked. A contributing factor in the incident was the inoperative annunciation system of the forward airstair…NTSB IAD00LA042Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Gettysburg, PAThe pilot's improper pre-flight which resulted in the fuel strainer valve being left in the open position.NTSB NYC00LA135Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Wellington, OHThe pilot's failure to maintain aircraft control. A factor was the pilot's improper in-flight decision to abort the initial climb due to an open canopy.NTSB DEN00LA088Accident · No injuriesLimited investigationFinal reportBeech V35B · Erie, COInadvertent cut off of the mixture by the pilot. Factors were: The passenger door opening, the pilot's inexperience in make and model, and rough, uneven terrain in the landing area.NTSB FTW00LA132Accident · No injuriesLimited investigationFinal reportCessna 140 · Hunter, OKThe pilot's inadequate preflight resulting in the loss of the oil cap and subsequent loss of engine oil. A factor was the lack of suitable terrain for the landing.NTSB CHI00IA125Incident · No injuriesIncident investigationFinal reportBoeing 777-223ER · Chicago, ILthe flightcrew not detecting the runway closure NOTAM and the Air Traffic Control personnel on the metering, ground, and local positions giving an improper clearance to taxi to a closed runway. Factors were the closed runway, ATIS information not issued by…NTSB NYC00LA120Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Lancaster, OHThe pilot's improper recovery from a bounced landing. A factor in the accident was the pilot's decision to operate the airplane over the maximum gross weight and his improper landing flare.NTSB SEA00LA076Accident · No injuriesLimited investigationFinal reportCessna 140 · Red Lodge, MTA high density altitude and inadequate preflight planning/preparation. Not attaining a proper climb rate, not maintaining a proper runway alignment, and gusting wind conditions were factors.NTSB LAX00LA156Accident · No injuriesLimited investigationFinal reportBell 407 · Grand Canyon, AZThe failure and subsequent disintegration of the oil cooler fan forward hanger bearing.NTSB LAX00FA151Accident · 1 fatalField investigationFinal reportBeech B36TC · Fullerton, CAThe pilot's failure to maintain adequate airspeed while in the traffic pattern, which resulted in an inadvertent stall/spin. Contributing factor was the pilot's diverted attention with the loss of engine power from his inadvertent activation of the auxiliary…NTSB SEA00IA062Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Seattle, WAContaminated air being ducted into the aircraft's cabin from the engine exhaust of a nearby ground power cart.NTSB SEA00IA057Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300-600 · Seattle, WAAn oil leak from the aircraft's APU that subsequently contaminated the aircraft's environmental system.NTSB SEA00IA050Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Seattle, WAThe flight crew's encounter with a suspicious device, which necessitated an emergency evacuation.NTSB ANC00IA034Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Fairbanks, AKA delayed rotation during takeoff for an undetermined reason.NTSB SEA00LA046Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-8-63F · Seattle, WAInadequate inspection of the number 1 and 2 engine cowls by company maintenance personnel and inadequate preflight inspection by the flight engineer, resulting in unsecured cowls separating from the aircraft during takeoff. A factor was unsecured number 1 and…NTSB LAX00LA100Accident · No injuriesLimited investigationFinal reportBell 47G5 · Riverbank, CAthe pilot's failure to verify that ground personnel had disconnected the loading hose from the hopper before takeoff, resulting in restricted directional control and a hard landing.NTSB NYC00IA078Incident · Minor injuriesIncident investigationFinal reportSaab-Scania 340B · Boston, MAThe vehicle driver's inadequate visual lookout.NTSB MIA00LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Englewood, FLThe failure of the pilot to retract the flaps from the fully extended position following the last landing resulting in the failure to maintain airspeed and subsequent descent for a forced landing. A contributing factor in the accident was the pilot's…NTSB NYC00LA070Accident · No injuriesLimited investigationFinal reportCessna 150 · Wiscasset, METhe pilot's inadequate preflight inspection.NTSB FTW00LA069Accident · No injuriesLimited investigationFinal reportCessna 310Q · Spring Branch, TXThe pilot's delay in aborting the takeoff. A factor was the open cabin door.NTSB CHI00LA059Accident · No injuriesLimited investigationFinal reportCessna 208B · Warsaw, INthe misjudged unsafe/hazardous condition by the pilot. Factors to the accident were the precautionary landing being performed by the pilot and the snow covered runway. Additional factors were the dark night, the snowing weather condition, the airport…NTSB LAX00LA063Accident · No injuriesLimited investigationFinal reportCessna 172G · Victorville, CAThe failure of the pilot to maintain positional awareness, which resulted in his becoming lost and disoriented. Contributing factors were the pilot's delay requesting assistance from air traffic control and the failure of the airplane's electrical generator.NTSB MIA00LA046Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Pikeville, NCThe inadequate supervision of the private-rated pilot by the certified flight instructor for allowing the airplane to impact terrain during a simulated forced landing procedure to an open field.NTSB CHI00LA023Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S57-A · Imperial, MOthe passenger's failure to follow instructions on how to properly brace for the landing.NTSB ANC00IA010Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Juneau, AKThe failure of the flight crew to provide a recommended landing traffic advisory, and the failure of flight service station personnel to provide a flight advisory to the arriving airplane concerning men and equipment operating on the runway. Factors in the…NTSB ATL00LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe student pilot's in-flight decision that resulted in the loss of engine power due to fuel exhaustion after he became lost and disoriented. A factor was the two fences.NTSB FTW00LA017Accident · No injuriesLimited investigationFinal reportWright Avid Flyer Mark IV · Seabrook, TXThe pilot's failure to maintain directional control during a downwind landing. Factors were his improper weather evaluation, the prevailing tailwind, and the engine vibration.NTSB MIA00LA010Accident · No injuriesLimited investigationFinal reportCessna 150M · Bunnell, FLThe erosion and separation of the aft end plate P/N 0450338-18 of the right muffler resulting in exhaust gas contact to electrical wires in the engine compartment. Also, unsuitable terrain encountered by the pilot during the forced landing. A finding in the…NTSB MIA00LA012Accident · No injuriesLimited investigationFinal reportBeech D35 · Indiantown, FLThe reported unauthorized use of the airplane by an unknown person.NTSB MIA00LA008Accident · 2 fatalLimited investigationFinal reportEddie A. Smith KR-2 · Bell Buckle, TNThe poor in-flight planning decision by the pilot-in-command for continuing the flight with inadequate fuel supply and the inadvertent stall by the pilot-in-command following total loss of engine power due to fuel exhaustion. Findings in the accident were the…NTSB NYC99LA229Accident · No injuriesLimited investigationFinal reportCessna 305A · Warehouse Point, CTThe pilot's misjudgment of the clearance between the airplane and the banner loop during banner pickup.NTSB LAX99LA264Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries Katana DA 20-A1 · San Carlos, CAThe release of the aircraft's left canopy latch following takeoff resulting in the subsequent opening of the canopy in flight. The opened canopy resulted in a degradation of aircraft control and the subsequent hard landing.NTSB MIA99LA207Accident · No injuriesLimited investigationFinal reportCessna 172M · Pierson, FLthe flight instructor's (pilot in command) failure to achieve the proper touch down point, his improper decision to continue the touch and go, and failure to abort the takeoff in sufficient time, resulting in the aircraft overrunning the runway and colliding…NTSB ANC99TA090Accident · No injuriesFinal reportBell 206B · Deadhorse, AKA failure of the pilot-in-command to perform an adequate preflight inspection, and remove a rotor blade tie-down strap.NTSB CHI99LA209Accident · No injuriesLimited investigationFinal reportCessna 180A · White Bear Lake, MNthe pilot's inability to get the airplane to climb for undetermined reason, and the pilot landing the floatplane on the lake with the wheels extended. Factors contributing to this accident were the pilot's failure to perform a before landing checklist,…NTSB MIA99LA179Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-180 · Wimauma, FLa passenger deplaning the airplane while the engine was running struck the propeller.NTSB FTW99LA165Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Panhandle, TXThe pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the noise heard by the pilot that resulted in his decision to execute a precautionary landing.NTSB SEA99LA098Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Pendleton, ORA fouled external load cable, and the pilot's operation of the helicopter with a non-approved external bucket installation, resulting in misrouted hydraulic lines and consequent malfunction of the external load release system.NTSB LAX99LA212Accident · Serious injuriesLimited investigationFinal reportBoeing 747-422 · Pacific Ocean (Pacific Ocean)intentional tampering/altering of a galley lift interlock microswitch by unknown persons.NTSB MIA99LA185Accident · No injuriesLimited investigationFinal reportBeech E-35 · Yankeetown, FLThe failure of maintenance personnel to balance check the ruddervators after painting the airplane and unclear information contained in the compliance section of AD 94-20-04 resulting in the failure of maintenance personnel to balance check the out-of-balance…NTSB IAD99LA047Accident · Serious injuriesLimited investigationFinal reportNanchang CJ-6A · Ocean City, MDWas the pilot leaving the magneto switch in the on position while hand rotating the propeller.NTSB SEA99LA062Accident · No injuriesLimited investigationFinal reportCessna 172M · Omak, WAThe pilot's failure to properly secure the aircraft before hand-propping.NTSB DCA99IA058Incident · No injuriesIncident investigationFinal reportAirbus Industrie 300-600 · Miami, FLUncommanded rudder movement caused by a contaminant in the engagement valve solenoid that prevented disengagement of the autopilot yaw actuator and cross-connected wiring of the autopilot yaw actuator's main valve solenoids by the operator. Factors…NTSB MIA99LA131Accident · 1 fatalLimited investigationFinal reportPiper J-3C · Jackson, MSThe failure of the airshow aerial performer to maintain a grip on the airplane's externally mounted rope ladder for unknown reasons and his failure to install and use a safety line resulting in his fall to earth. A factor in the accident was the sudden…NTSB LAX99LA181Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · La Verne, CAThe in-flight separation of the right engine cowling due to the operator's inadequate maintenance quality control procedures and the pilot's inadequate preflight inspection.