NTSB investigations, 1992
149 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 177 |
|---|---|
| 1983 | 260 |
| 1984 | 220 |
| 1985 | 186 |
| 1986 | 184 |
| 1987 | 182 |
| 1988 | 194 |
| 1989 | 141 |
| 1990 | 134 |
| 1991 | 144 |
| 1992 | 149 |
| 1993 | 132 |
| 1994 | 115 |
| 1995 | 141 |
| 1996 | 148 |
| 1997 | 139 |
| 1998 | 135 |
| 1999 | 132 |
| 2000 | 146 |
| 2001 | 120 |
| 2002 | 140 |
| 2003 | 140 |
| 2004 | 122 |
| 2005 | 113 |
| 2006 | 114 |
| 2007 | 121 |
Where
Latest cases
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 year(c.\"eventDate\") = 1992
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130)
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 year(c."eventDate") = 1992 AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130) 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 CHI93IA060Incident · No injuriesIncident investigationFinal reportBeech B90 · Sioux Falls, SDThe pilot-in-command's inadequate preflight.NTSB SEA93LA045Accident · No injuriesLimited investigationFinal reportCroy KR-2M · Gillette, WYJamming of the nose landing gear door opening mechanism and the pilot in command's excessive descent rate upon touchdown.NTSB SEA93LA038Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Arco, IDA leaking crankshaft oil seal, and snow on the landing area.NTSB ANC93LA021Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe total loss of engine power due to a short in the voltage regulator, and the lack of suitable terrain for the pilot to make the forced landing on.NTSB CHI93FA050Accident · 1 fatalField investigationFinal reportCessna 177B · Kansas City, MOThe pilot-in-command's failure to maintain a positive rate of climb during a missed approach. Factors which contributed to the accident were: inoperative gyro instruments due to a broken vacuum pump, the dark night, adverse weather conditions, and rising…NTSB SEA93FA032Accident · 1 fatalField investigationFinal reportCessna 152 · Marysville, WAThe design stress limits of the airframe were exceeded by the student pilot.NTSB LAX93LA058Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Fresno, CAThe pilot's inadequate preflight. Contributing to this accident was the separation of the fuel cap, tail rotor blade balance weight, tail rotor gear box, and the vertical fin.NTSB FTW93LA047Accident · No injuriesLimited investigationFinal reportHiller UH12B · Justin, TXFailure of the main rotor system for undetermined reasons. A factor was the lack of suitable terrain at the pilot's disposal.NTSB CHI93GA046Accident · 2 fatalFinal reportSchweizer 269C · Kansas City, MOThe pilot-in-command's misjudging the distance during the autorotation.NTSB MIA93LA022Accident · Minor injuriesLimited investigationFinal reportMason, Jack A. Velocity · Crystal River, FLFailure of an unknown individual to determine that the propeller was properly secured after removal of the propeller spinner, resulting in separation of one of the propeller blades during cruise flight. Contributing to the accident was unsuitable terrain…NTSB MIA93LA039Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Dorado, PRPoor in flight planning decision by the pilot in command. Contributing to the accident was the partial blockage of the pitot static system and incorrect airspeed indicator.NTSB LAX93LA044Accident · No injuriesLimited investigationFinal reportHughes 369D · Carlsbad, CAFailure of the overrunning clutch assembly bearing for undetermined reasons.NTSB LAX93FA033Accident · No injuriesField investigationFinal reportSabreliner N-265-60 · Phoenix, AZThe delay of the PIC to apply normal braking and his failure to execute the appropriate emergency procedures. Contributing to this accident was an undetermined antiskid malfunction; the copilot's inexperience in the aircraft; and inadequate crew coordination.NTSB LAX93IA029Incident · No injuriesIncident investigationFinal reportPiper PA-31T-620 · Medford, ORFatigue failure of the elevator control tube rod end bearing resulting in a loss of elevator control.NTSB SEA93LA019Accident · No injuriesLimited investigationFinal reportBeech A35 · Vancouver, WADesign stress limits of the aircraft were exceeded.NTSB CHI93LA015Accident · No injuriesLimited investigationFinal reportBeech K35 · Scott City, KSFailure of the alternator and the pilot's inadvertent descent.NTSB LAX93LA017Accident · 1 fatalLimited investigationFinal reportPasporello, J.F. RV-3 · Lompoc, CAThe failure of an unidentified airframe or component system for unknown reasons and the resulting inflight fire.NTSB DEN93LA006Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Grand Junction, COFatigue failure of the nose landing gear upper drag strut bracket due to fatigue cracking.NTSB ATL93LA013Accident · No injuriesLimited investigationFinal reportPatrick F. Bowers Corbin JR. ACE E · Woodstock, GAThe separation of the propeller from the aircraft.NTSB DEN93IA005Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Denver, COAn inadvertent attempt, by unknown persons, to start the APU which had been placarded as inoperative. Factors were: inadequate procedures in rendering the APU incapable of being started when inoperative.NTSB FTW93LA007Accident · No injuriesLimited investigationFinal reportCessna 210G · Little Rock, ARThe partial failure of the landing gear retraction/extension assembly from restricted hydraulic fluid movement through a partially failed main landing gear uplock release valve.NTSB SEA93FA002Accident · 4 fatalField investigationFinal reportBeech N35 · Burlington, WAThe failure of screws on the propeller hub during takeoff, the improper inflight decision by the pilot to return for landing, and the steep, excessive bank angle which resulted in a stall/spin and loss of control.NTSB FTW93FA002Accident · 1 fatalField investigationFinal reportClatanoff Rotorway Exec · Wimberley, TXThe delamination of the skin on a main rotor blade.NTSB BFO92LA154Accident · No injuriesLimited investigationFinal reportCessna 305A · Waynesville, OHThe chaffing of a landing gear brake line which caused the loss of hydraulic fluid and subsequent loss of braking action.NTSB LAX92LA400Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Middletown, CAThe pilot's failure to connect the elevator control during assembly and failure to perform an adequate aircraft preflight check. Contributing to the accident was the pilots distraction by performing other tasks during the assembly procedure.NTSB BFO92FA144Accident · 2 fatalField investigationFinal reportHughes 269C · East Bernstadt, KYInadequate maintenance inspection involving failure to detect wear of the clutch spring assembly, resulting in the uncoupling of engine power to the main transmission.NTSB BFO92LA143Accident · Serious injuriesLimited investigationFinal reportGrumman AA-1A · Bedford, MAInadequate maintenance inspection which failed to reveal a deteriorated rudder cable which subsequently failed and caused loss of directional control.NTSB MIA92LA189Accident · No injuriesLimited investigationFinal reportCessna 210L · Orlando, FLUndetected chaffing and grounding of a wire to the nose landing gear squat switch which resulted in the landing gear being signalled at all times for gear up when electrical power was applied to the system. Contributing to the accident was the overheating of…NTSB MIA92LA188Accident · No injuriesLimited investigationFinal reportCessna 210L · Orlando, FLFailure of the right main landing gear actuator due to overstress for undetermined reasons which resulted in loss of all landing gear system hydraulic fluid which in turn resulted in the pilot being unable to extend and lock the landing gear.NTSB FTW92LA230Accident · No injuriesLimited investigationFinal reportCessna 172P · Fulshear, TXThe pilot's failure to attain the proper point of touchdown. Factors were the popped circuit breaker, the inoperative alternator, and the darkness of the night.NTSB BFO92IA145Incident · No injuriesIncident investigationFinal reportLockheed L1011-385 · Boston, MAInadequate lubrication which caused stress corrosion cracking and the separation of the right wing number two flap vane.NTSB FTW92GA227Accident · No injuriesFinal reportCessna T210L · Spring, TXThe pilot under instruction failure to follow the landing checklist and the instructor pilot's inadequate supervision. A factor was the overheated landing gear motor.NTSB FTW92LA225Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Victoria, TXBlocked engine assembly breather tube and the pilot's continued operation with known maintenance discrepancies. Factors were oil on windsheild and reduced visibility due to oil on the windscreen..NTSB MIA92LA181Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Panacea, FLFailure of the nose landing gear push/pull rod end bearing for undetermined reasons.NTSB CHI92DEC04Accident · Serious injuriesFinal reportTennessee Engineering & Manf Z-MAX · Manchester, MIAn inadequate design of the rudder control system by the pilot/builder of the airplane, a pullup performed by the pilot, and a total failure of the rudder flight control system.NTSB ANC92FA164Accident · 3 fatalField investigationFinal reportMcdonnell Douglas 369D · Eagle, AKAn inflight fatigue failure and separation of a main rotor blade, inadequate operator maintenance and inspection, and material defect.NTSB MIA92LA179Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Satartia, MSFailure of the brake system due to installation of a bogus part by an unknown person. Directional control by the pilot in command was not possible.NTSB ANC92FA159Accident · Serious injuriesField investigationFinal reportHughes 369D · Nunavaugaluk Lk, AKThe separation of the tail rotor abrasion strip and the subsequent total loss of the tail rotor. Factors contributing to the accident were: insufficient manufacturer's maintenance design changes, inadequate aircraft equipment design by the manufacturer and…NTSB CHI92FA267Accident · 1 fatalField investigationFinal reportPiper PA-61-601P · Aurora, INExceeding the design stress limits of the airplane by the pilot in command.NTSB ANC92LA175Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Ptarmigan Pass, AKThe partial failure of the normal brake system, the misjudging of the proper touchdown point and the attempted go around. Factor was the rough and uneven landing area.NTSB MIA92LA177Accident · No injuriesLimited investigationFinal reportCessna A150K · Palatka, FLThe pilot in command's failure to maintain airspeed while performing a go around resulting in the aircraft stalling and descending uncontrolled to the ground.NTSB BFO92LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-30K · Schaghticoke, NYThe loss of total engine power due to fuel starvation. Contributing to the accident was the loss of total electrical power.NTSB CHI92LA281Accident · No injuriesLimited investigationFinal reportCessna 172RG · Wheeling, ILMain landing gear collapse as a result of the failure of a landing gear hydraulic pump seal.NTSB LAX92FA374Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Concord, CAThe following Probable Cause was modified on April18, 2007, as a result of new information provided to the NTSB. The improper installation of the 1.75 inch od plug in the crankshaft by unknown maintenance personnel which resulted in an inadvertent feathering…NTSB ATL92IA169Incident · No injuriesIncident investigationFinal reportSaab-Scania 340B · Chattanooga, TNThe failure and subsequent seizure of the reduction gear box, and the failure of the propeller control unit as a result of contaminated oil supply which is shared with the gear box.NTSB ANC92IA147Incident · No injuriesIncident investigationFinal reportShort Brothers SH-7 · Sheldon Point, AKThe unlatching of the left crew entrance door by means undetermined and the lack of adherence to door check items by the pilot in command on the requisite checklists. A factor relating to the incident was the separation of the door from the frame when opened…NTSB CHI92IA260Incident · No injuriesIncident investigationFinal reportDouglas DC-8-61 · Morton Grove, ILFailure of the right main landing gear door actuator.NTSB MIA92LA167Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Miami, FLFailure (short) of a diode located inside a transformer which is located in the no. 1 generator control unit.NTSB ANC92GA155Accident · No injuriesFinal reportBell 206B · Fairbanks, AKPoor maintenance and inspection procedures by the contract maintenance personnel, as well as improper maintenance and installation of the fuel line by the contract maintenance personnel. Factors relating to the accident were the turboshaft engine vibrations…NTSB MIA92IA166Incident · No injuriesIncident investigationFinal reportDouglas DC-8-71F · Miami, FLFailure of the aircraft operator maintenance personnel to adequately lubricate and seal the main landing gear bogie beam swivel joint as required by manufacturer and operator maintenance program requirements. This allowed moisture to enter the swivel joint…