NTSB investigations, 1992
28 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1982 | 35 |
|---|---|
| 1983 | 18 |
| 1984 | 43 |
| 1985 | 44 |
| 1986 | 51 |
| 1987 | 43 |
| 1988 | 43 |
| 1989 | 45 |
| 1990 | 28 |
| 1991 | 45 |
| 1992 | 28 |
| 1993 | 22 |
| 1994 | 15 |
| 1995 | 28 |
| 1996 | 36 |
| 1997 | 44 |
| 1998 | 25 |
| 1999 | 32 |
| 2000 | 41 |
| 2001 | 40 |
| 2002 | 24 |
| 2003 | 37 |
| 2004 | 34 |
| 2005 | 33 |
| 2006 | 34 |
| 2007 | 34 |
Where
Open the mapLatest 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\" = 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 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" = 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 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.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.