Final NTSB investigations: Boeing 737-3TO
9 cases on aircraft the registry lists as Boeing 737-3TO. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1988 | 2 |
|---|---|
| 1989 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 1999 | 2 |
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 c.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('138447G'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('138447G'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 MIA99FA252Accident · No injuriesField investigationFinal reportBoeing B737-300 · West Palm Beach, FLThe fatigue fracture and separation of the high pressure turbine forward rotating air seal due to a manufacturing defect in a bolt hole that was not detected by the engine manufacturer due to inadequate and ineffective inspection techniques. Contributing to…NTSB NYC99LA076Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Newark, NJThe flight attendant's failure to follow cabin door opening procedures.NTSB NYC99IA024Incident · No injuriesIncident investigationFinal reportBoeing 737-3TO · Newark, NJA loss of torque on the apex nut of the shimmy damper for undetermined reason(s), which resulted in a failure of the shimmy damper, and the subsequent failure of the lower torsion link of the right main landing gear.NTSB MIA95LA133Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Tallahassee, FLThe failure of a passenger to comply with flight crew instructions to remain seated with her seat belt fastened which resulted in her being injured while walking in the aisle during a turbulence encounter.NTSB FTW95IA053Incident · No injuriesIncident investigationFinal reportBoeing B-737-300 · Houston, TXThe failure of maintenance personnel to follow the taxi checklist resulting in the hydraulic pumps not being turned on.NTSB MKC90IA070Incident · Minor injuriesIncident investigationFinal reportBoeing 737-300 · Wichita, KSImproper installation of level arm.NTSB DCA89MA034Accident · No injuriesMajor investigationFinal reportBoeing 737-300 · Oakland, CAIgnition of puddled fuel from a blocked combustor drain line, and a slow start during which fuel was misted and blown out the tail pipe. An existing tailwind at the gate allowed the fuel to wet the tail surfaces and be ignited during the APU start. The…NTSB FTW88IA141Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Kenton, DEA flameout of the #1 engine occurred due to water ingestion when the aircraft penetrated a vip level 5 thunderstorm and encountered heavy rain while descending with the throttles a flight idle. The engine suffered overtemperature damage to the turbine section…NTSB NYC88IA109Incident · No injuriesIncident investigationFinal reportBoeing 737 · Morristown, NJBoeing 737 (N69348) was depg newark intl arpt as a lear jet 24 (N500NH) was depg fm teterboro. Both were being ctld by new york TRACON (newark sector). The strip for the 737 was mismarked as a north departure rather than an east departure. The instructor/full…