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 CHI92LA143Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 · Ionia, MIThe pilot-in-command's improper preflight and decision to close the glider's canopy at low altitude.NTSB DEN92IA050Incident · 1 fatalIncident investigationFinal reportBoeing 757-222 · Denver, COThe captain suffered a fatal heart attack.NTSB FTW92FA112Accident · 2 fatalField investigationFinal reportBell 206L-3 · Venice, LAThe pilot's incapacitation due to food poisoning.NTSB LAX92LA147Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Phoenix, AZThe ground guide's failure to follow established procedures and his improper visual lookout by failing to remain clear of the nose gear during the push back operation.NTSB FTW92IA092Incident · No injuriesIncident investigationFinal reportBell 206L-3 · Sabine Pass #18The pilot's cardiovascular disease.NTSB ANC92LA042Accident · No injuriesLimited investigationFinal reportPiper PA-18A-135 · Paxson, AKThe pilot failed to attain & maintain takeoff airspeed. Factors to the accident were: takeoff was performed with a tailwind, and inadequate remedial action.NTSB SEA92LA058Accident · No injuriesLimited investigationFinal reportCessna 207 · Seattle, WAThe cargo door unlatched for undetermined reasons.NTSB CHI92LA042Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fargo, NDThe pilot's improper interpretation of instructions issued by air traffic control specialist, and the pilot's poor inflight planning and decision(s). Factors associated with the accident are the confusing communications by the air traffic control specialist,…NTSB ATL92IA030Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-310-200 · Covington, KYThe improper installation of the thrust reverser stow switch assembly by company maintenance personnel, which resulted in the erroneous illumination of the thrust reverser warning light.NTSB MIA92FA045Accident · 1 fatalField investigationFinal reportCessna 152 · Naples, FLThe pilot-in-command's incapacitation due to an undetermined cardiovascular event which resulted in an uncontrolled descent into the ground.NTSB LAX92LA055Accident · No injuriesLimited investigationFinal reportCessna 421B · San Andreas, CAThe pilot's inadequate preflight inspection and his failure to follow the airplane's checklist. A contributing factor was the dark night condition.NTSB MIA92LA031Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Mariner · Ocala, FLThe pilot-in-command's improper use of collective control and throttle during recovery from an autorotation which resulted in loss of rotor RPM and a subsequent hard landing.NTSB MIA92LA027Accident · 1 fatalLimited investigationFinal reportBeech BE-35 · St. Petersburg, FLThe passenger's loss of balance resulting from a previous impairment.NTSB LAX92FA043Accident · 3 fatalField investigationFinal reportCessna 172M · Carmel Valley, CAThe pilot's failure to maintain a safe altitude above the ground during an intentional low altitude flight in mountainous terrain. Contributing factors related to the pilot becoming distracted while flying over the ground and to his failure to initiate a…NTSB ATL92LA022Accident · Serious injuriesLimited investigationFinal reportBritish Aerospace 3101 · Memphis, TNThe failure of the ramp agent to position an additional step below the last step of the airstair door and the ground; the agent failed to follow a verbal company procedure.NTSB MIA92LA021Accident · Minor injuriesLimited investigationFinal reportNorth American Navion · Okeechobee, FLOperation by the owner/pilot-in-command with known deficiencies in equipment and fuel starvation due to a blocked fuel line.NTSB MIA92LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tylertown, MSOil fouling of the windshield due to a loose engine oil seal. A factor was the pilot's preexisting vision impairment.NTSB MIA91LA226Accident · Minor injuriesLimited investigationFinal reportCessna 172C · Palm Beach, FLTotal loss of engine power due to fuel exhaustion, and failure of the pilot to refuel before departure. Contributing to the accident was the pilot's lack of total experience in becoming lost/disoriented, and operation with known deficiencies in equipment.NTSB MIA91LA222Accident · Serious injuriesLimited investigationFinal reportHoffmeyer Moni Standard · Brooksville, FLIncapacitation of the pilot in command and inadvertent stall mush.NTSB LAX91IA415Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A-320-231 · Santa Ana, CAThe failure of the flight attendant assigned to the aft galley jumpseat to secure a beverage cart in accordance with company policy.NTSB CHI91LA299Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Boscobel, WIImproper remedial action by the pilot-in-command (PIC), and inadequate monitoring by the designated pilot examiner (DPE) during a simulated emergency procedure. Factors related to the accident were: the loss of power in one engine due to an undetermined…NTSB FTW91LA161Accident · Serious injuriesLimited investigationFinal reportBarnes AX 7 · Baytown, TXThe crewmembers improper posture during landing which led to a serious injury.NTSB DEN91FA127Accident · 2 fatalField investigationFinal reportButler Aerostar 600 · Ruidoso, NMLoss of control in flight after to the cabin door opened inadvertently during takeoff run.NTSB CHI91LA280Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Algonquin, ILIncapacitation of the pilot due to a heart attack.NTSB LAX91FA366Accident · Serious injuriesField investigationFinal reportPiper PA-32RT-300 · Van Nuys, CA(1) The pilot's improper preflight preparation; (2) the pilot's failure to follow the airplane manufacturer's performance data by his selection of an improper flap position for takeoff; and (3) the pilot's choice of a runway too short for a safe takeoff.…NTSB MIA91IA199Incident · Minor injuriesIncident investigationFinal reportBritish Aerospace BA-3100 · Fort Myers, FLThe physiological incapacitation of the captain and his loss of consciousness due to a syncopal pleural event.NTSB LAX91LA360Accident · No injuriesLimited investigationFinal reportCessna 182 · Long Beach, CAThe failure of the pilot to perform a proper preflight inspection of the aircraft.NTSB CHI91LA231Accident · No injuriesLimited investigationFinal reportLet L-13 · Gregory, MIA collision with wires after the glider overshot the landing area due to inadvertent lowering of the flaps and no use of spoilers.NTSB CHI91FA228Accident · 2 fatalField investigationFinal reportRobinson R 22B · Carmel, INThe pilot's delaying remedial action. Factors in the accident were the pilot's failure to attain adequate rotor RPM for takeoff, failure to abort takeoff and lack of total experience in helicopters.NTSB LAX91LA318Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Chico, CAThe pilot's improper starting procedure.NTSB BFO91LA073Accident · Minor injuriesLimited investigationFinal reportBeech H50 · Hartwood, VAThe parachutist failure to properly monitor and secure his release handle to protect against accidental parachute deployment.NTSB LAX91LA306Accident · 1 fatalLimited investigationFinal reportCessna 182 · Wailua, HIThe accidental deployment of jumpers reserve parachute inside the airplane.NTSB MIA91LA181Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Everglades City, FLUnsuitable terrain encountered during a precautionary landing.NTSB BFO91FA060Accident · 1 fatalField investigationFinal reportPiper J5 · Berlin, MDThe pilot's failure to maintain adeqate airspeed which caused the airplane to stall.NTSB FTW91LA110Accident · Minor injuriesLimited investigationFinal reportBeech B19 · Addison, TXEntry door opening in flight, inadequate emergency procedures published by the manufacturer, and poor emergency training by the student's instructor. Factors were inadequate design/installation of the door locking mechanism, deteriorated airplane performance,…NTSB LAX91LA274Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Santa Maria, CAOil starvation due to the pilot's failure to properly configure the aircraft for the flight during the preflight inspection.NTSB CHI91LA183Accident · 1 fatalLimited investigationFinal reportBalloon Works FIREFLY-7B · Greenwood, MOThe inadequate briefing to the ground crew by the pilot, because the ground crewman did not understand the intent and objectives of the maneuver.NTSB SEA91LA126Accident · Serious injuriesLimited investigationFinal reportBoeing 737-3G7 · Elko, NVAn unsecured cart. The factors to the accident were: turbulent weather conditions, and poor judgement by the flight attendant.NTSB CHI91LA179Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Battle Creek, MIAircraft control by the dual student was not maintained, remedial action by the CFI was delayed, which resulted in a stall/mush. A factor related to the accident was rough water caused by a power boat wake.NTSB ATL91LA060Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Greensboro, NCA failure of the left magneto grounding lead resulting in a 'hot magneto' condition.NTSB MIA91LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Vero Beach, FLFailure of the PA-28 pilot to maintain proper brake pressure, while diverting his attention to his notepad.NTSB ATL91FA074Accident · 3 fatalField investigationFinal reportBeech 60 · Kinston, NCThe pilot diverted his attention and failed to maintain control of the aircraft, while maneuvering for a precautionary landing. Factors related to the accident were: the unsecured baggage compartment door and the pilot's inadequate preflight.NTSB MIA91LA112Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sanford, FLExcessive flare by the dual student during the forced landing following a simulated engine failure shortly after takeoff. Also, failure of the student to maintain vs, and failure of the CFI to take remedial action.NTSB CHI91DEE03Accident · Minor injuriesFinal reportAir Command Gyrocopter · Lansing, ILThe pilot's delayed pullup. A factor in the accident was the pilot's exessive rate of descent during the spiral maneuver.NTSB MIA91LA094Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Greenwood, MSFailure of the student pilot to abort the flight when one of the two fuel quantity indicators became inoperative during the first leg of the flight. Also, inaccurate fuel consumption calculations, poor preflight planning, and poor supervision by the CFI who…NTSB FTW91LA048Accident · 1 fatalLimited investigationFinal reportBell 206B II · High Island, TXFor occurrence #1 - inadequate supervision by the operator in launching a hazardous mission without an adequate sling/harness, the pilot's poor judgement in accepting and continuing the mission into low light conditions, and the crewmember's inadvertent…NTSB CHI91DEM03Accident · No injuriesFinal reportHuddleston/Becktold Glasair · Lansing, MIFailure of the instructor pilot (CFI) to maintain sufficient airspeed on final approach to flare the aircraft for landing. Factors related to the accident were: the landing gear malfunction, and the cfi's improperly planned approach.NTSB ATL91IA044Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE Jetstream 3201 · Charlotte, NCThe failure of the captain to follow checklist procedures, resulting in a flight with the cabin door unsecured, and the subsequent loss of the cabin door.NTSB NYC91LA066Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Williamstown, MAThe failure of the pilot to retract the speed brakes during the preflight, which resulted in the tow airplane being unable to attain sufficient altitude prior to releasing the glider, and the subsequent landing of the glider on unsuitable terrain.NTSB CHI91LA087Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Indianapolis, INThe pilot's failure to use proper procedures and the improper use of the throttles.