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 CHI94LA227Accident · No injuriesLimited investigationFinal reportCessna 441 · Flint, MIAn inadequate preflight inspection of the airplane by the pilot. Factors associated with this accident were unlatched nose cargo doors and the pilot's failure to extend the landing gear.NTSB ATL94LA098Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-B · Burlington, NCInadvertent burner control interference by the passenger. A factor was the presence of electric transmission wires at the forced landing site.NTSB MIA94LA118Accident · No injuriesLimited investigationFinal reportCessna 310J · Ocala, FLFailure of the pilot to assure the generators were engaged before flight (failed to follow the checklist).NTSB NYC94LA062Accident · Serious injuriesLimited investigationFinal reportDouglas DC-8-61 · Covington, KYThe captain's improper decision to conduct flight at high altitude in an unpressurized airplane, which resulted in his incapacition from depressurization sickness. A factor related to the accident was: maintenance personnel failed to properly secure the…NTSB ANC94IA037Incident · No injuriesIncident investigationFinal reportBoeing 747-200F · Anchorage, AKThe attempt, by the pilot in command, to attempt takeoff with the parking brake controll engaged, resulting from incorrect procedures by the pilot in command.NTSB CHI94IA095Incident · Minor injuriesIncident investigationFinal reportBritish Aerospace ATP · Mosinee, WIthe inadequate design of the PBSI electrical switch(es), and the operator's failure to expeditiously implement corrective Service Bulletins.NTSB MIA94IA043Incident · No injuriesIncident investigationFinal reportBoeing 767-322 · Miami, FLEmergency procedure initiated by an unqualified person.NTSB FTW94LA056Accident · No injuriesLimited investigationFinal reportBeech 35 · Crystal Beach, TXWas a total loss of engine power for undetermined reasons. Factors were a passenger door inadvertently opening in flight due to inadequate preflight by the pilot, unsuitable terrain for the forced landing, and carburetor icing conditions.NTSB CHI94LA016Accident · No injuriesLimited investigationFinal reportCessna 150J · Grosse Ile, MIThe pilot misjudged altitude/clearance during the banner pickup, which resulted in the tow rope snagging the landing gear, and failed to maintain adequate airspeed, while landing with the banner attached, which resulted in a failure (or inability) to attain a…NTSB FTW94LA033Accident · Serious injuriesLimited investigationFinal reportBell 204-B · Cedar Crest, NMFailure of ground personnel to follow published procedures. A factor was the the load jettison.NTSB LAX93LA371Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Kepuhi Molokai, HIA loss of main rotor RPM for undetermined reasons.NTSB LAX93LA366Accident · 1 fatalLimited investigationFinal reportCessna 182H · Flagstaff, AZthe pilot's sudden incapacation due to a fatal heart attack.NTSB BFO93LA155Accident · Serious injuriesLimited investigationFinal reportDouglas MD-88 · Lexington, KYThe cabin attendant did not follow published procedures.NTSB NYC93LA174Accident · Serious injuriesLimited investigationFinal reportCameron HAB-N90 · Niagara Falls, NYThe inadequate bracing of the passenger for landing which resulted in a fall.NTSB MIA93LA181Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Delray Beach, FLThe pilot-in-command's/flight instructor failure to communicate his intentions with the student pilot to effect a positive transfer of the flight controls, and improper handling of the airplane on landing roll out, resulting in an on ground collision with a…NTSB LAX93LA289Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · La Jolla, CAthe failure of the injured ground crewman to release his hold on the basket in a timely manner when instructed by the pilot.NTSB LAX93LA279Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Coloma, CAthe passenger's injury to an ankle during the landing touchdown.NTSB ANC93LA088Accident · No injuriesLimited investigationFinal reportCessna 185 · Arctic Village, AKThe pilot's selection of unsuitable terrain for a landing. A factor related to the accident was: the soft/thin (weak) ice condition of the lake surface.NTSB LAX93IA245Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Los Angeles, CAthe inadvertent deployment of an overwing emergency excape slide due to the inadequate latching of the slide compartment door following access by maintenance personnel. A factor in the accident was the inadequate door closing procedure specified by the…NTSB BFO93GA102Accident · 2 fatalFinal reportBeech B24R · Manassas, VAFailure of the pilot to maintain adequate airspeed while maneuvering for a precautionary landing which resulted in an inadvertent stall. A related factor was that the pilot's attention was diverted by the open door.NTSB LAX93LA217Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Jean, NV1) The pilots inadequate preflight inspection of the aircraft, 2) his failure to adequately compensate for the existing gusty wind conditions, and, 3) his failure to maintain an adequate landing approach airspeed. Contributing to the accident was the pilots…NTSB CHI93LA327Accident · Serious injuriesLimited investigationFinal reportBritish Aerospace ATP · Green Bay, WIthe passenger's loss of footing (miscellaneous).NTSB CHI93IA127Incident · No injuriesIncident investigationFinal reportde Havilland SHD-6 · Chicago, ILThe local controller's failure to maintain 3 miles radar separation between two airplanes. A factor related to the incident was the local controller's delay in remedial action.NTSB CHI93IA126Incident · No injuriesIncident investigationFinal reportATR ATR 42 · Chicago, ILAn improper clearance by the north local controller, which resulted in a failure to maintain proper IFR separation. A factor related to the incident was: inadequate coordination among the tower personnel.NTSB CHI93IA125Incident · No injuriesIncident investigationFinal reportATR ATR 72 · Chicago, ILthe local controller's failure to issue a proper heading clearance which resulted in a loss of radar separation between two departing airplanes.NTSB CHI93IA115Incident · No injuriesIncident investigationFinal reportde Havilland SHD-6 · Chicago, ILFailure of the approach and local controllers to maintain IFR separation standards between all the airplanes on the approach.NTSB NYC93IA064Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Newark, NJThe pilot's disorientation while taxiing, resulting in a runway incursion. Factors contributing to the incident were: the failure of the flight crew to communicate with the ATC ground controller to verify their position; the inadequate crew coordination; and…NTSB FTW93IA064Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC9-82 · Dfw Airport, TXThe inaccurate safety advisory provided by the tower operator. A factor was the emergency evacuationNTSB DEN93IA025Incident · No injuriesIncident investigationFinal reportBoeing 767-222 · Denver, COMedical incapacitation of the first officer.NTSB FTW93IA048Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120RT · Houston, TXThe assigned mechanic's failure to reinstall the attachment screws and the quality inspector's inadequate inspection of the completed work. A factor was the complacency of the maintenance personnel.NTSB CHI93LA045Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Milwaukee, WIThe pilot's failure to maintain a proper altitude.NTSB CHI93LA043Accident · Serious injuriesLimited investigationFinal reportBoeing 727-232 · Chicago, ILThe captain's inadequate coordination with the ground and flight crew. Factors related to the accident were: the passenger's perception that the APU exhaust was a fire, which resulted in action that initiated an evacuation.NTSB ATL93LA024Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Atlanta, GAThe inadequate procedures and training of ground personnel involved in the aircraft push back operations by company management.NTSB ANC93LA015Accident · No injuriesLimited investigationFinal reportBell 206B III · Elf Point Camp, AKThe pilot misjudged clearance and dragged an external load longline cable while landing.NTSB CHI93IA019Incident · No injuriesIncident investigationFinal reportPiper PA-28-181 · Chicago, ILThe failure of the midway arsa controller to coordinate use of the airspace with the Chicago north local controller which resulted in an operational deviation. A factor related to the incident was the pilot's failure to follow his assigned heading.NTSB FTW93LA005Accident · No injuriesLimited investigationFinal reportBeech C24R · Fayetteville, ARThe pilot's delayed flare. A factor was the pilot's failure to properly secure the door prior to takeoff.NTSB FTW93LA001Accident · No injuriesLimited investigationFinal reportBeech D18S · Brookston, TXSmoke trailing from the left engine for an undetermined reason(s). Factors contributing to the accident were unsuitable terrain conditions.NTSB FTW92LA235Accident · No injuriesLimited investigationFinal reportErcoupe 415-G · Gallup, NMThe instructor pilot's lack of familiarity with the performance capability of the aircraft. Factors were the rising terrain and high density altitude.NTSB ATL92LA177Accident · No injuriesLimited investigationFinal reportAir Command Commander · Mars Hill, NCThe pilot's premature rotation before sufficient rotor speed had been attained to support flight. A factor was the rough sod airstrip.NTSB ANC92LA145Accident · No injuriesLimited investigationFinal reportCessna 150 · Chicken, AKThe pilot's selection of unsuitable terrain. Contributing factors were the pilot inadvertently became lost/disoriented, her lack of total expereince, her lack of familiarity with the geographical area, the poor lighting condition (dusk), and the weather…NTSB MIA92FA156Accident · 4 fatalField investigationFinal reportBell 47J2 · Adjuntas, PRThe failure of the pilot-in-command to maintain adequate rotor RPM during a precautionary landing following the loss of engine oil. In addition, the pilot failed to insure that the engine contained adequate oil, and that the oil dip stick was secure prior to…NTSB LAX92LA316Accident · No injuriesLimited investigationFinal reportCessna 177 · Turlock, CAThe pilots poor planning in not properly securing the aircraft with tiedowns, chocks or brakes prior to attempting to start the engine by hand propping.NTSB MIA92LA153Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G103 · Knoxville, TNThe pilot-in-command's failure to properly instruct the passenger on aircraft controls prior to takeoff, resulting in the passenger inadvertently releasing the tow cable as the glider was being towed through 150 feet.NTSB FTW92LA183Accident · No injuriesLimited investigationFinal reportCessna 180K · Curlew Island, LAThe pilot's selection of unsuitable terrain for landing. A factor was the pilot's physical impairment.NTSB SEA92LA151Accident · No injuriesLimited investigationFinal reportBerkshire Mfg. Concept 70 · Ephrata, WAInadequate in-flight planning/decision. Factors to the accident were: no thermal lift and rough/uneven terrain.NTSB CHI92LA208Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Kendallville, INImproper remedial action, the pilot's failure to maintain airspeed, and the failed tow rope.NTSB LAX92LA275Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Olancha, CA1) The tow pilot's intentional premature release of the glider, which had become airborne, when the tow plane failed to achieve sufficient airspeed during its takeoff ground roll, and, 2) the glider having insufficient altitude at the time of release to…NTSB LAX92LA262Accident · Serious injuriesLimited investigationFinal reportBell 47-G5A · Pago Pago (Pacific Ocean)The pilot's inadequate preflight inspection in failing to ensure that all skid tiedowns were removed prior to the attempted takeoff.NTSB ANC92LA082Accident · Minor injuriesLimited investigationFinal reportChampion 7GCB · Snow Lake, AKThe pilot's failure to keep the aircraft on the step and he allowed it to become airborne. The pilot subsequently lost depth perception, and his failure to maintain proper rate of descent, resulting in a hard landing and collapse of the float landing gear. A…NTSB SEA92LA098Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35C · Big Timber, MTAirspeed was not maintained. Factors to the accident were: no thermal lift and inadequate remedial action.